Setting up an electrical register in Excel with expiry dates
 

I am currently setting up an electrical register using Excel 2003 which
shows a date column of when the equipment has to be retested. I would like
to have the date columns in green, then two weeks before the expiry date,
have them change to yellow. Once the date has expired, I would then like the
column to change to red. Can you please explain if this can be done using
formulas in Windows XP 2003.

Thanks
Scotty

Setting up an electrical register in Excel with expiry dates
 

Hi,

The answer is conditional formatting. have a look here

http://www.mrexcel.com/articles/due-...formatting.php
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Scotty" wrote:

I am currently setting up an electrical register using Excel 2003 which
shows a date column of when the equipment has to be retested. I would like
to have the date columns in green, then two weeks before the expiry date,
have them change to yellow. Once the date has expired, I would then like the
column to change to red. Can you please explain if this can be done using
formulas in Windows XP 2003.

Thanks
Scotty