Hi,

I have a date in a cell. If this date is within the next 3 months then I
need the cell to be shaded red. And then when the date expires it needs to be
shaded red also...

How can I achieve this? I have Excel 2000 by the way.

Many Thanks