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.
Yes. 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
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