Forum Discussion
Conditional Formatting
Select the range with the dates.
Set the fill color to green.
This will be the default.
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 blue as highlight color.
Click OK, then click OK again.
Repeat these steps, but with the formula
=TODAY()-90
and red as fill color.
Right I just tried that and now The Dates are green but everything else is Red. The Dates don't color themselves properly when I change them
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- https://1drv.ms/x/s!AkNieIxqhd6NgS2YymFDwQp9CcWD?e=mlUIh1 Here I Deleted all sensitive data. Thanks for all your help and Patience
