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