Conditional Formatting stopped working

[dscowden14]

For years I have a cell (C3) which compares a total on 12 different tab to the total on the data source tab. That number is in C3, and the total of the 12 tabs is on B30, both on the same tab. I have had the conditional formatting set using a formula, =C3<>B30, to alert me when these totals do not match. Well today, the cell turned red, but the totals match! Nothing changed, and I verified all totals. Everything ties out, but the cell stays red, which is only supposed to occur when they do not match. Can't figure this out. Thanks.

dscowden14

 

[Joe4]

Perhaps you have a rounding or floating decimal precision issue working here.
Try changing your formula like this and see if it works:

=ROUND(C3,2)<>ROUND(B30,2)

 

[dscowden14]

I had taken the decimal out to 4 places before when trying to figure it out, but it must have been a smaller amount. The formula worked! Thanks for the tip.

dscowen14

 

[Joe4]

You are welcome.