Dear Brad, Good Afternoon.
To do exactly what you need, DO:
Conditional Formatting
1° CONDITION
Formula: =TODAY()-H2=2
Format: Green colour
2° CONDITION
Formula: =TODAY()-H2=1
Format: Orange colour
3° CONDITION
Formula: =TODAY()-H2<=0
Format: Red colour
Teel me if it worked for you.
Mazzaropi
Quote:
Originally Posted by Braduzzz
HI
I have a spreadsheet which has a date on it (H2), When it comes to two days before the date i want it to go green, then one day before the date i need it go orange, then on the day its due i need it go red and stay red after the date has been passed and then i just need it to stay with no formatting before any of these days are reached.
e.g
<20/2/2011 (no formatting
21/2/2011 (cell to turn green)
22/2/2011 (cell to turn orange)
23/2/2011 (date in cell, date its due)
24/2/2011 (Cell to turn red)
25/2/2011 (Cell to stay red)
Many Thabks
Brad
|