none
Excel 2010: Conditional Formatting

    Question

  • I have one row with numbers, and I am comparing them to a second row of numbers.  I want these numbers to match.  If made a =IF formula that another row should display 100 if they match and 0 if they do not match:

    (Trying to attach image here, but it saysBody text cannot contain images or links until we are able to verify your account. - I have had this account for years, just not on the forums.)

    anyway the image is here: hxxp://tinypic.com/r/2jbrthf/6

    I then went to conditional formatting and did this:

    hxxp://tinypic.com/r/2isy52f/6

    but nothing happens, the cells do not change.  However, if  I use "Format only cells that contain" and make 2 rules, it works.  The problem is that when you choose format cells there are no options for icons, only fills and bold etc.

    How can I make this work????
    Thanks.


    • Edited by Swimmer613 Sunday, March 03, 2013 1:49 AM stabalize format
    Sunday, March 03, 2013 1:34 AM

Answers

  • Hi,

    The issue is caused by the formula, you make the 100 and 0 format as Text, so Conditional Formatting will not recognize the value.

    Change the formula as:

    =IF(B60=B62,100,0)


    Jaynet Zhang
    TechNet Community Support

    • Marked as answer by Swimmer613 Monday, March 04, 2013 8:28 PM
    Monday, March 04, 2013 9:43 AM
    Moderator

All replies

  • Hi,

    The issue is caused by the formula, you make the 100 and 0 format as Text, so Conditional Formatting will not recognize the value.

    Change the formula as:

    =IF(B60=B62,100,0)


    Jaynet Zhang
    TechNet Community Support

    • Marked as answer by Swimmer613 Monday, March 04, 2013 8:28 PM
    Monday, March 04, 2013 9:43 AM
    Moderator
  • Thank you, removing the quotation marks worked perfectly.
    Monday, March 04, 2013 8:30 PM