Forum Discussion
Solved
put color date
In an excel table, I have column "A" which contains folder names.
Column "B" contains the date when the file must be completed.
I would like :
- the cell in column A is on a GREEN background if tod...
In French, the TODAY() function is named AUJOURDHUI()
So use
=$B2>AUJOURDHUI()+15
and
=$B2>=AUJOURDHUI()
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?
In French, the TODAY() function is named AUJOURDHUI()
So use
=$B2>AUJOURDHUI()+15
and
=$B2>=AUJOURDHUI()
- Thanks a lot, it works !