Conditional Format Greater Then and Formula Less Then issues

I have a formula in Cell H14 to calculate a value

Please Login or Register  to view this content.

Then I have a conditional format for the same cell (H14).
The conditional format is "If cell value is >H13" format the font red.

The conditional format appears to work. Except for when the numbers are equal. I'm guessing it's because it really isn't equal. I have went out 30 decimal places and it shows all zeros. I have tried "TRUNC" and "ROUND" with no luck. Any ideas/suggestions?

I also have another similar problem with this formula

Please Login or Register  to view this content.

It works, except when the values are equal (or appear to be).

Thanks very much for your time and help!

Hi
Try to use
=IF(H14-G13)<=1E-13,"X","")

Hello Jose,
Unfortunately, that did not work either.

I have also tried the INT function for the other problem. I think it should work, but it doesn't

Please Login or Register  to view this content.

Try this

Formula:

Please Login or Register  to view this content.

Originally Posted by FDibbins

Like, how? Can you show what you tried?

(you probably need to apply that to both sides of the equation)

Sure... this is what I tried using TRUNC

Please Login or Register  to view this content.

Originally Posted by FDibbins

Like, how? Can you show what you tried?

(you probably need to apply that to both sides of the equation)

Sure... this is what I tried using TRUNC

Please Login or Register  to view this content.

Originally Posted by JeteMc

It might help if you could attach the workbook or a sample workbook that exhibits the same behavior, so that we can see what is going on.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Ok... I have tried to attach the file.

Thanks!

That works...
Thanks!!!