Excel 2000 - Highlighting a date.

Giganews Newsgroups
Subject: Excel 2000 - Highlighting a date.
Posted by:  onequestion
Date: Tue, 7 Aug 2007

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

Replies