Highlighting cells with a greater time of 3hours from another cell

[Cris F]

Hi there,

First time post on this forum. Looking for some help with the following...

I have two separate columns with varying times. The first column contains an arrival time and second column with a completion time.

I need the second column completion time to automatically highlight once the manually entered time has surpassed 3 hours after the first column arrival time.

Hope that makes sense! If anyone can help, it would be appreciated.

Cris

 

[yky]

Enter the following formula into Conditional Formatting, choose a fill color, then, copy and paste by format down the column:

=B1-A1>3/24 'substitute with appropriate columns

 

[Cris F]

Hi YKY,

Thanks, I've tried using your suggestion and unfortunately still no luck.

Used this formula under cond. formatting greater than =$I$7-$F$7>3/24 and still not luck.

Any other suggestions or need some more info?

Tks.

 

[yky]

Would you post some real data?