Forum Discussion
put color date
In French, the TODAY() function is named AUJOURDHUI()
So use
=$B2>AUJOURDHUI()+15
and
=$B2>=AUJOURDHUI()
Select the folder names in column A. I will assume that A2 is the active cell in the selection.
On the Home tab of the ribbon. select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula =$B2>0
Click Format...
Activate the Fill tab.
Select red.
Click OK, then click OK again.
Repeat the above steps, but with the formula =$B2>=TODAY() and yellow as fill color.
And repeat them again with the formula =$B2>TODAY()+15 and green as fill color.
- This is working with one cell but did i have to do that with all the cells?
Lionreaux You were supposed to select the entire range with folder names, and then create the conditional formatting rules. That way the rules will apply to all selected cells.
HansVogelaar, hmm this isnt working when i select the entire range and i dont understand why...
Sorry my excel is in french so maybe the problem is the way that i write my dates?
