+ Reply to Thread
Results 1 to 2 of 2

Highlighting duplicates, using 2 columns as the key

  1. #1
    Registered User
    Join Date
    11-05-2011
    Location
    Malta
    MS-Off Ver
    Excel 2007
    Posts
    5

    Highlighting duplicates, using 2 columns as the key

    So, I know it's possible to use conditonal formatting to highlight duplicates, however, what I don't know is if there is a way to compare the value of TWO rows with another TWO rows and only highlight if both rows are duplicates.

    In my attached sample file, I have the following values in A1, A2, B1, B2:

    EUR 5
    USD 5

    and in E1, E2, F1, F2:

    EUR 5
    USD 4

    In this scenario, I only want A1, B1, E1, F1 to be highlighted as duplicates because they both contain "EUR" and "5" respectively, the other has a different value in at least 1 cell so no highlighting should be shown

    Is this possible to do?

    sample.xlsx

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Highlighting duplicates, using 2 columns as the key

    Try using something like this as the conditional formatting criteria for A1:B2.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Then for E1:F2
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlighting duplicates
    By nick2price in forum Excel General
    Replies: 10
    Last Post: 08-30-2014, 10:15 AM
  2. Replies: 6
    Last Post: 02-16-2013, 07:29 AM
  3. Highlighting every other set of duplicates
    By IUgrad04 in forum Excel General
    Replies: 3
    Last Post: 12-27-2011, 08:08 AM
  4. Highlighting the duplicates in Eight rows:
    By Flower R in forum Excel General
    Replies: 10
    Last Post: 12-17-2008, 10:19 PM
  5. [SOLVED] highlighting duplicates
    By alex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2006, 01:45 PM
  6. [SOLVED] highlighting duplicates
    By Lynn in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-11-2005, 11:05 AM
  7. Help with Highlighting all duplicates in a row
    By Jimv in forum Excel General
    Replies: 4
    Last Post: 04-21-2005, 03:06 PM

Tags for this Thread

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