+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting: Duplicate rows based on multiple columns.

  1. #1
    Registered User
    Join Date
    03-12-2014
    Location
    Central Texas
    MS-Off Ver
    Excel 2010
    Posts
    55

    Question Conditional Formatting: Duplicate rows based on multiple columns.

    Hi all,
    I do apologize if this has been asked and/or answered before, when I tried searching, all I got was thousands of entries that didn't seem to quite catch what I'm looking for.
    I will try to explain this right: I'm looking for a Conditional Formatting formula that will check two columns before highlighting the duplicate rows. I need it to be conditional formatting because I know nothing about writing macros or vba (what-ever that is?).
    Data is entered into Columns A, B, and C. I need to check both column A and C before it highlights the duplicates, based on those two columns. (The format only unique or duplicate values checks only one column.)
    I have attached an example, but this is just an example, as I have hundreds of lines to go through on the original. (For this example, Row 2 and Row 7 are the duplicates I need highlighted.)

    Any help would be appreciated. Thanks in advance.

    Example.xlsx

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Conditional Formatting: Duplicate rows based on multiple columns.

    This can be done with the help of a helper column which you can hide. For detail see the attached sheet.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    03-12-2014
    Location
    Central Texas
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Conditional Formatting: Duplicate rows based on multiple columns.

    That works great! Thank you very much.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Conditional Formatting: Duplicate rows based on multiple columns.

    Glad to help you. Thanks for the feedback.

+ 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. Finding duplicate rows based on values in multiple columns
    By jamie1985 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-03-2014, 08:21 AM
  2. [SOLVED] Conditional formatting for multiple rows and columns
    By jimboryan in forum Excel General
    Replies: 2
    Last Post: 04-17-2013, 01:38 PM
  3. Conditional Formatting - Multiple Rows and Columns
    By mltucc in forum Excel General
    Replies: 2
    Last Post: 04-20-2012, 10:30 PM
  4. Conditional Formatting - Multiple rows/columns
    By Phillydog in forum Excel General
    Replies: 4
    Last Post: 03-21-2011, 04:50 PM
  5. concatenate rows with columns based on conditional formatting in VBA?
    By bandit_kaine in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2010, 03:16 AM

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