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

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