you have to set different format pattern colours with each formula.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Dom" wrote in message
...
Hi, thanks for getting back to me. I've tried putting those in and it
changes
the cell to green but doesn't change to red when the cell is over one hour
any ideas?

"Bob Phillips" wrote:

=H1TIME(1,0,0)

=H1<=TIME(1,0,0)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Dom" wrote in message
...
Hi,
I'm trying to get the cell colour to change depending on the time
difference
between two times. In cell F i have the date and time i recieved a
report
and
in cell G the date and time i chased the jobs on the report in cell H
is
the
difference between the two and if this is under one hour i want it to
be
green and if over one hour to be red. The difference is displayed in
dd:hh:mm. Can anyone help i've tried several formulas but can't seem to
get
it to work. Any help would be appreciated. Thank you