Conditional format 30-60-90 days to 1year old

ThomasWade 

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.