Forum Discussion
Formulate cells to change colour
This can be done using conditional formatting.
Select F4 (plus cells below if want to format multiple rows).
On the Home tab of the ribbon, select Conditional Formatting >New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND($E4<>"",$E4<=EDATE(TODAY(),3))
Click Format...
Activate the Fill tab.
Select yellow.
Click OK, then click OK again.
Repeat the above steps with the formula
=AND($E4<>"",$E4<=EDATE(TODAY(),1))
and red.
This can be done using conditional formatting.
Select F4 (plus cells below if want to format multiple rows).
On the Home tab of the ribbon, select Conditional Formatting >New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND($E4<>"",$E4<=EDATE(TODAY(),3))
Click Format...
Activate the Fill tab.
Select yellow.
Click OK, then click OK again.
Repeat the above steps with the formula
=AND($E4<>"",$E4<=EDATE(TODAY(),1))
and red.
