Forum Discussion
Colour formatting for dates
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'll be honest formulas is like brain surgery to me so be gentle please.
Thanks.
Mark
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.
3 Replies
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.
=D1>TODAY()+30
=NOT(D1>TODAY()+30)
Maybe with these rules for conditional formatting as shown in the attached file.
