Results 1 to 4 of 4
  1. #1
    Star Lounger
    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(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. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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?

  3. #3
    Uranium Lounger
    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

  4. #4
    Star Lounger
    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!

Posting Permissions

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