conditional formatting based on time difference

[dombrosm]

I am having trouble creating rules for conditional formating based on the time difference between a static time value in a given cell (time due completion) and the NOW function. I would like to have the format of cells change as the time difference changes.
I would like to have cells that are 4 hours or less from the completion time highlight yellow, and cells 2 hrs or less from completion highlight red.
When I try and subtract a future time value (the time due completion) from a cell with the NOW function, I get an error. I can subtract two cells with static times without any issues but that does not help me with what I need to do.
Does anyone know how I can use excell to do this?

 

[VoG]

This seems to work but I think it will be erroneous for due times in the past.

Excel Workbook
	A
1	Time due
2	22/05/2010 13:00
3	22/05/2010 15:00
4	22/05/2010 17:00
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	1. / Formula is =(A2-NOW())*24<2	Abc
A2	2. / Formula is =(A2-NOW())*24<4	Abc

 

[dombrosm]

Thanks for the help. I did not know that I had to multiply the difference by 24 hours.
One more thing, we use GMT to track all of our times, is there a easy way to offset the NOW time by X number of hours to adjust for local time differences?

 

[VoG]

To offset by +1 hours try

=NOW()+1/24

and format as date + time.