Forum Discussion
Cannot understand why Conditional Formatting is not functioning correctly
Attached you will find a screen shot of two exact conditional formatting. One is working correctly on one worksheet and the other will not work correctly. Worksheet #2 is the one in question. On t...
SergeiBaklan I believe you are exactly right by this. In evaluating the formula for these cells I see that the result is a long amount after the decimal (ie: 41.65 = 41.6499999999942)-see attached screen snip shot. I have tried to figure out why this is even calculating as such a long decimal number when the amount is in dollars and cents. I am at my wits end with this.
If you format in dollars and cents, or apply any other format, that doesn't change the value in the cell, it only changes the way as this value is shown.