Conditional Formatting Problem (2000)

Topic

New Reply

I’m trying to apply conditional formatting to a cell (G9) that when the value in that cell does not equal the value in another cell (Q1), the font is made bold and changes color and the cell is shaded with color, e.g. conditional formatting would be applied because the two values are $490.27 & $490.20.

It seems to be a problem that the cell I’m trying to apply the conditional format to contains a formula, rather than a straight number, e.g. =SUM(G7-G8) e.g. = $490.27.

I’ve tried inputting as, Cell Value Is Not Equal to =$Q$1and as Formula is =$Q$1$G$9, but neither work; however, if I remove =SUM(G7-G8) and replace it with a number a number that does not equal the value in Q1, e.g. $490.20, it works as it should. Not sure why a calculated value would cause a problem with the conditional formatting.

Thanks for any help provided.

Scott

Reply | Quote

Replies

Both methods you describe should work; it shouldn’t matter whether Q1 contains a value or a formula. Could you attach a small workbook demonstrating the problem?

Reply | Quote

That is most likely caused bu rounding errors in the math. If you display 15 digits in the cell with the SUM formula, you will probably see that the number is not exactly equal to 490.27. Try this formula in the conditional format:

=ROUND($Q$1,2)ROUND($G$9,2)

Reply | Quote

The rounding formula worked! Thanks for your help!

Reply | Quote