Conditional Formatting, problem with cell colour fill based on another cell value

Hi,

Am experiencing a problem, and hoping someone can help - I have a formula that subtracts 24hr times

Formula:

Please Login or Register  to view this content.

, one from another (cell A1-A2 to give a result in A3, in hh:mm). I also have a similar table that I am trying to get conditional formatting to highlight the cell (A3) in green, if the value in cell B3 is of the same value. I can do this using conditional formatting if no formula is present in cell A3, but cannot get conditional formatting to work if the formula is present - any ideas greatly appreciated!.

Hi Tony,

Many thanks for the reply, and yes indeed, the formula you gave also works very nicely....

And yes, there is a formula in B3 cell, which is the reason why I think I cannot get CF to work?

Ah, your other thread was closed, but Tony's response covers it. Here is what I tried to post to your other thread:

You can use a formula for your conditional format like this:

=F6-N6<0.000000001

Time values are stored as fractions of a 24-hour day, and as such you can have very small variations in values (corresponding to fractions of a second) which prevent you from using a formula like:

=F6=N6

as they are not truly identical.

Hope this helps.

Pete

Firstly, apologies for thread duplication.......

Tony, Pete....many thanks for that....at last the "light bulb" moment has occurred for me....and see what you are both saying now.....I hadn't comprehended that the time results from the formula I had in place wasn't exact (i'm a little thick sometimes!), and therefore for CF to work, it needed to be rounded.....doh!

Many thanks once again....works perfectly now