Hello Roger,
Thanks for the information below, however I am unable to get your
formula to work with conditional formatting. Here are the steps I took
to try and implement your suggestion. BTW - I am currently using Excel
2003,
- Selected the cell A2 which has Date & Time information in it that
is within an hour of the current time
- Selected *Format* *Conditional Formatting*
- Under Condition 1 I set the drop-down to *Formula Is* and entered
the formula *=AND(A2NOW(),A2-NOW()<TIME(1,0,0))*
- Clicked *Format* within the dialog box and selected *Paterns*
*Yellow*
Here is a sample of the Date & Time format that is being produced by
the SQL database: Oct 4 2005 6:00PM
Please let me know if there are any steps I am missing in order to have
conditional formatting monitor for Dates & Times that are within 1 hour
of the current time.
Thank you,
Rob S
--
robs
------------------------------------------------------------------------
robs's Profile:
http://www.excelforum.com/member.php...fo&userid=4098
View this thread:
http://www.excelforum.com/showthread...hreadid=472878