Forum Discussion
Solved
Conditional format 30-60-90 days to 1year old
I am trying to automatically highlight a date when it is 30-60-90 days from its due date but I want to use the date a certificate was issued. Example: I have a cert that was issued on 5-26-2021 and e...
Select the cells that you want to format.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop-down set to 'Cell Value'.
Select 'less than or equal to' from the second drop-down.
In the box next to it, enter the formula =EDATE(TODAY(),-9)
Click Format...
Activate the Fill tab.
Select yellow.
Click OK, then click OK again.
Repeat the above steps, but with the formula =EDATE(TODAY(),-10) and orange as fill color.
Finally, repeat them again, this time with the formula =EDATE(TODAY(),-11) and red as fill color.
You need to use relative reference for rows and apply the rule to entire range. Instead of
it will be
SergeiBaklan that did it - thank you
CaptYankee330 , glad it helped