Setting up an electrical register in Excel with expiry dates
in [Functions]
|
Prev: where text wraps in a cell, how can the row height be auto set
Next: Can I combine a Vlookup with an IF formula?
From: Scotty on 15 Apr 2010 05:43 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
From: Mike H on 15 Apr 2010 06:12
Hi, The answer is conditional formatting. have a look here http://www.mrexcel.com/articles/due-dates-with-conditional-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 > |