Results 1 to 4 of 4

20050426, 20:01 #1
 Join Date
 Feb 2003
 Posts
 60
 Thanks
 0
 Thanked 0 Times in 0 Posts
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(G7G8) 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(G7G8) 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

20050426, 20:10 #2
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 Posts
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?

20050426, 20:16 #3
 Join Date
 Jan 2001
 Location
 South Carolina, USA
 Posts
 7,295
 Thanks
 0
 Thanked 0 Times in 0 Posts
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>
Legare Coleman

20050427, 10:42 #4
 Join Date
 Feb 2003
 Posts
 60
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Conditional Formatting Problem (2000)
The rounding formula worked! Thanks for your help!