View Single Post
 
Old 04-20-2015, 09:08 AM
Saywarder Saywarder is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Apr 2015
Posts: 1
Saywarder is on a distinguished road
Default Question re: Conditional formatting (cell occurs after another cell)

Example:
D3 is "3/31/2015 7:30:00 PM"
D4 is "4/1/2015 12:00:00 AM"

I would like D4 to be automatically formatted (red text) because it occurs longer than 3 hours after D3. Is this possible?

Slightly different, D5 is "=NOW()", would the formatting for the above also work on the date that D5 gives (will be 48 hours).

Thank you very much,
Micheal
Reply With Quote