conditional formatting help

L

Little Penny

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
 
P

p45cal

Little said:
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
Click to expand...
In xl2003:
322
if in 2007 post again - go to thecodecage.com to see the image if it'
not visible

+-------------------------------------------------------------------
|Filename: 2009-10-15_030243.jpg
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=322
+-------------------------------------------------------------------
 
Top