Forum Discussion
Stuck with Conditional Formatting
I've searched high and low and not getting anywhere I need. It's probably so simple but I just can't get it to work. I've got a training matrix document. I need a column to adjust the color base...
Select the cells in column B, starting with B2.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'greater than' from the second drop down,
Enter 0 in the box next to it.
Click Format...
Activate the Fill tab.
Select red.
Click OK, then click OK again.
Repeat these steps, but instead of 0, enter the formula =EDATE(TODAY(),-24) in the box, and select orange as fill color.
Finally repeat them again with the formula =EDATE(TODAY(),-23) and green as fill color.
For the range in column C, starting in row 2, follow the same instructions, but with the formula =EDATE(TODAY(),-36) for orange and =EDATE(TODAY(),-35) for green.