Forum Discussion
Conditional Formatting with Dates and coloring per rules
Hello I have a Spreadsheet with a set of people and for each of them columns with formulas that bring the date a visit should occur. That formula is a number of days after the first visit (over a per...
Select the range that you want to format conditionally. I will assume that R2 is the active cell in the selection.
Set the fill color to strong red - 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 'greater than' from the second dropdown.
In the box next to it, enter the formula =TODAY()-11
Use the version for your language - probably =HOY()-11
Click Format...
Activate the Fill tab.
Select light red.
Click OK, then click OK again.
Repeat these steps, but with =TODAY() and orange.
Finally, repeat them again with =TODAY()+10 and light salmon.