+ Reply to Thread
Results 1 to 3 of 3

How to Compare two columns and highlight both if Same Value

  1. #1
    Registered User
    Join Date
    01-26-2012
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    1

    How to Compare two columns and highlight both if Same Value

    Hi i am okay at using microsoft excel but i am really lost with this! I want to compare two columns of Number and if the numbers match i want it to highlight these columns!
    here is a screenshot of what i want to do. Could some one Please Please help me! this would mean me actually keeping my Job!!!!
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    01-26-2012
    Location
    Gloucestershire, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to Compare two columns and highlight both if Same Value

    Quote Originally Posted by tommeh View Post
    Hi i am okay at using microsoft excel but i am really lost with this! I want to compare two columns of Number and if the numbers match i want it to highlight these columns!
    here is a screenshot of what i want to do. Could some one Please Please help me! this would mean me actually keeping my Job!!!!
    Using a vlookup formula in conditional formatting works for me. Highlight each column in my example and click on Conditional formatting > Manage rules to see what I've done.

    This is in Excel 2010, not sure how this will work in other versions.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-26-2012
    Location
    Gloucestershire, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to Compare two columns and highlight both if Same Value

    Um, thinking about it, you should probably use something more robust as a formula like:

    =IF(ISNA(VLOOKUP(A2,C:C,1,FALSE)),FALSE,TRUE)

    This way you're not relying on the number that's being looked up being greater than zero. It'll highlight it as long as the vlookup finds it in the other column.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1