# Thread: Conditional Formatting Problem (2000)

1. ## Conditional Formatting Problem (2000)

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

2. ## Re: Conditional Formatting Problem (2000)

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?

3. ## Re: Conditional Formatting Problem (2000)

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:

<pre>=ROUND(\$Q\$1,2)<>ROUND(\$G\$9,2)
</pre>

4. ## Re: Conditional Formatting Problem (2000)

The rounding formula worked! Thanks for your help!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•