Forum Discussion
Solved
Colour formatting for dates
Afternoon all, Wondering if anyone can help me out here. I've got a list of dates and I want Excel to highlight it Green if there's more than 30 days from now till date shown and red if less. I'...
Select the cells you want to format.Set the fill color to green. This will be the default.
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 'less than' from the second drop-down.
Enter =TODAY()+30 in the box next to it.
Click Format...
Activate the Fill tab.
Select red.
Click OK, then click OK again.
