Forum Discussion
Conditional format 30-60-90 days to 1year old
- Aug 08, 2021Select 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. 
With permission of all, here are some additional examples for the solution proposed by Mr. Hans Vogelaar.
Thank you for your time.
Nikolino
I know I don't know anything (Socrates)