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