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
|