Quote:
Originally Posted by ArviLaanemets
Here you go!
I set the Conditional Format for overtime, you can easily add formats for various warnings (adding/removing the number of years/months in DATE() function in formula),
|
thank you!, I am guessing if I wanted a conditional format after 6 months would it be
=DATE(YEAR(B4) + B$2, MONTH(B4), DAY(B4))<TODAY()-182