Conditional formatting anomaly....

I'm applying some conditional formatting so that the number in H2 should be blue if it is above zero , green at zero , and red below zero.

This works fine if the number in D2 is a single number , but it fails to work if D2 contains a formula giving the same number. This is really puzzling. Can anyone advise as to why this should be?

I'll attach my file.

Grateful for any help.

Ok thanks for your help.

I can see that on expanding the cell to 20 places that the number is curiously a negative.

Rounding to two places doesn't seem to make any difference to the reaction of the conditional formatting as the underlying figure is still being viewed as negative.

I can't see a way of forcing it to read it as two places and therefore apply the correct formatting.

Maybe you could advise if a formula in the CF interface would have the desired effect.

Presently , I'm applying identical CF to cells both showing the same output , and am getting different responses...

I put the following formula in H2, and it changed the formatting to green, which is what I believe your goal is:

Please Login or Register  to view this content.

However, I'm baffled by the negative result in the original formula.

After poking around a little bit, I found this site that explains the weird math:

https://www.atlaspm.com/toms-tutoria...ding-up-wrong/

Hopefully this doesn't violate any link posting rules.