Forum Discussion
Conditional format 30-60-90 days to 1year old
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.
HansVogelaar What formula would I use to make a date change color after 15 and 30 days? =EDATE(today(),-15)
=A1 > TOADY() - 15- So, I am applying three rules to these cells?
1. cell is green
2. cell changes to yellow after 15 days
3. cell changes to red after 30 daysYes. One colour - one rule. To the cell or to the range, depends on your data.
SergeiBaklan Thank you!
I was able to use this answer to apply 3 rules to an entire row based on one cell in that row.
But I can't figure out an easy wasy to propagate those 3 rules to all rows but keep it relative.
I'm not sure if I need to use a name or ???
If you can provide simple instructions that'd be good so I know how to do it myself next time.
I've attached my file for reference
