Forum Discussion

Mark1750's avatar
Mark1750
Copper Contributor
Jan 14, 2022
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'...
  • HansVogelaar's avatar
    Jan 14, 2022

    Mark1750

    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.

Resources