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()
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 !