+ Reply to Thread
Results 1 to 3 of 3

Highlighting multiple duplicates based on two columns

  1. #1
    Registered User
    Join Date
    12-22-2020
    Location
    Alverstoke, England
    MS-Off Ver
    365
    Posts
    25

    Highlighting multiple duplicates based on two columns

    Hi,
    This is driving me insane as it seems so simple, but not for me!
    I'm hoping my example sheet explains it all, but if not please do ask.

    Any help is greatly appreciated.

    Thank you
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-11-2021
    Location
    CANADA
    MS-Off Ver
    Excel 2007, Office 2019
    Posts
    31

    Re: Highlighting multiple duplicates based on two columns

    Select B2:B29 then go to

    Conditional Format > Use a last option "Use a formula to determine which cell to format"


    =COUNTIF($A$2:$A$5,$B2)

  3. #3
    Registered User
    Join Date
    12-22-2020
    Location
    Alverstoke, England
    MS-Off Ver
    365
    Posts
    25

    Re: Highlighting multiple duplicates based on two columns

    Thank you very much. Works perfectly. I appreciate your help

+ 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 based on the date it's under.
    By mutzie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2019, 12:24 AM
  2. [SOLVED] highlighting duplicates if the cells match between multiple columns
    By R.Sloan in forum Excel General
    Replies: 4
    Last Post: 07-25-2017, 08:01 AM
  3. Finding and highlighting duplicates accross columns
    By Aries86 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-21-2016, 07:26 PM
  4. Highlighting duplicates, using 2 columns as the key
    By Santoryuu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-21-2015, 11:09 AM
  5. [SOLVED] Deleting Duplicates Based on Multiple Criteria from Multiple Columns
    By Franklic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2012, 05:31 PM
  6. Highlighting duplicates based on how many times they're duplicated
    By aking in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 08-19-2012, 08:41 AM
  7. Duplicates Based on Multiple Columns
    By Kolin in forum Excel General
    Replies: 9
    Last Post: 06-30-2010, 12:09 PM

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