View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Little Penny[_4_] Little Penny[_4_] is offline
external usenet poster
 
Posts: 13
Default conditional formatting help

Is it possible to use conditional formatting based of the time? I have
a spreadsheet and in column I there is a date time value (10/14/09
12:30 PM). What I'd like to do is:

If the current time is more that13 hours before the time value in
column (I) I' like the row to remain white.

If the current time is within 13-1 hours I'd like to highlight the row
yellow.

If the current time is within 1 hours or current time is past the time
value in column (I) I'd like to highlight the row red.

Any help is greatly appreciated


Thanks