View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
 
Posts: 519
Default Two part question about dates and highlighting

Hello from Steved

I have the date in cell A5 which is 11/12/06

Firstly after 24 hours are up I wold the cell E5 to be highlited with the
color purple.

Secondly the same as above but after 3 daysin cell F5, and also after 1 week
in cell G5.

Thankyou. ps there are over 100 rows.