Forum Discussion
Conditional Formatting using dates
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?
- Hi, Please see attached.
https://docs.google.com/spreadsheets/d/1zI3Qdaxw9yesSUVvlGePWuGOV4_EB3rP/edit?usp=sharing&ouid=107628387144989397156&rtpof=true&sd=trueThank you.
Select the cells you want to format. It's OK to include empty cells.
Start by setting the fill color to green. That will be the default.
On the home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Lave the first drop-down set to 'Cell Value'.
Select 'less than or equal to' from the second drop-down.
Enter the formula =TODAY() in the box next to it.
Click Format...
Activate the Fill tab.
Select orange.
Click OK, then click OK again.
Repeat these steps, but with the formula =TODAY()-14 and red.
Finally, repeat them again, with 'equal to' instead of 'less than or equal to', with the formula ="" and 'No Color'.
Hi HansVogelaar
That sounds great in practice, but its not giving me what I want.
Today is 31/01/2023.
Anything that is 31/01/2023 and upto and including -14 days (17/01/2023) needs to be orange.
Anything that is 31/01/2023 and -15 days( 16/01/2023) and over needs to be Red.
Anything from 01/02/2023 needs to be green.
I would be most grateful for a solution 🙂
