+ Reply to Thread
Results 1 to 2 of 2

Highlight duplicate rows based on column A but be case sensitive

  1. #1
    Registered User
    Join Date
    10-09-2006
    Posts
    36

    Highlight duplicate rows based on column A but be case sensitive

    I'm looking to highlight duplicate rows of data based on column A.

    The comparison must be case sensitive.

    So
    blah
    blah
    are duplicates

    Blah
    blAh
    are not duplicates.

    Currently I can use the default conditional formatting function to find duplicates. However it is not case sensitive. Regardless of upper or lower case, if the exact phrase is there it thinks they are duplicates.

    Is there a method to also search for duplicates and highlight them but take in to account the case as well?

    Thx

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Highlight duplicate rows based on column A but be case sensitive

    Hey, I learned something new.

    Assume your values run from A2:A5000:

    Highlight Cell A2, choose Conditional Format -> Based on Formula

    =1/EXACT($A$2:$A$5000,A2)

    Choose a fill color, hit Okay.

    Use Format Painter and copy downwards as far as needed


    As far as using Control+F to search for duplicates, just click the advanced tab and just click "match case" if you want to do it manually.

+ 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. Making duplicate filter case sensitive
    By JustStep25 in forum Excel General
    Replies: 4
    Last Post: 01-12-2018, 02:59 AM
  2. [SOLVED] Highlight Duplicate Rows Based on Multiple Criteria
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2013, 09:39 AM
  3. Replies: 2
    Last Post: 05-27-2012, 09:43 AM
  4. Replies: 0
    Last Post: 07-22-2011, 12:11 PM
  5. Highlight rows based on Duplicate with conditions
    By ypnOz in forum Excel General
    Replies: 5
    Last Post: 12-28-2010, 09:50 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