Forum Discussion
Conditional Formatting - DATE
I'm looking for a formula that would format dates that are within 30 days or past due in a column. I've got it set up now for within 30 days but once it passes TODAY date, the cell reverts back to green. I'd also like it to not alter any blank cells in column only cells with dates within 30 days and past due. Any help would be appreciated. Thank you.
1 Reply
Select the range you want to apply this to.
Remove existing conditional formatting rules, if any.
On the home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'less than or equal to' from the second drop down.
In the box next to it, enter the formula=TODAY()+30
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.Repeat these steps to create a new rule, with the following changes:
'equal to' instead of 'less than or equal to',
="" instead of =TODAY()+30
No Fill instead of a color.
