Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts
    A coworker wants to compare data in 6 columns, and if the cells match, she wants them marked somehow (probably just a background color will do).
    For example, columns D, E, and F compared to columns L, M and N. IF D, E,F do not match what is in L,M and N, then shade the mis-matched cells so she can easily find the discrepancy.

    I figured out how to use conditional formatting to compare two columns, but I'm clueless about comparing multiple cells.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I assume that you want to compare D to L, E to M and F to N. So it's simply a matter of comparing pairs of columns.

    See the attached version: [attachment=87230:Compare multiple.xls]
    Attached Files Attached Files

  3. #3
    Lounger
    Join Date
    Mar 2009
    Location
    INDIA
    Posts
    35
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Slinky View Post
    I assume that you want to compare D to L, E to M and F to N. So it's simply a matter of comparing pairs of columns.

    See the attached version: [attachment=87230:Compare multiple.xls]
    Hi,

    Want to thanks the querier and the answerer, as I was looking for the same solution .

    Thanks !!

  4. #4
    2 Star Lounger
    Join Date
    Jun 2010
    Location
    philippines
    Posts
    185
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by MelanieB View Post
    A coworker wants to compare data in 6 columns, and if the cells match, she wants them marked somehow (probably just a background color will do).
    For example, columns D, E, and F compared to columns L, M and N. IF D, E,F do not match what is in L,M and N, then shade the mis-matched cells so she can easily find the discrepancy.

    I figured out how to use conditional formatting to compare two columns, but I'm clueless about comparing multiple cells.
    by using conditional formating you may set rules liked highlight duplicate values or so and so.

Posting Permissions

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