Results 1 to 4 of 4

Conditional formatting - highlight unique/duplicate values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-09-2013
    Location
    City, World
    MS-Off Ver
    Office 365
    Posts
    248

    Conditional formatting - highlight unique/duplicate values

    Hi
    I created 2 rules to highlight duplicate and unique value respectively using the following formulas:

    For duplicated
    =COUNTIF($A$2:$A$20,A2)>1
    for unique
    =COUNTIF($A$2:$A$20,A2)=1

    I also selected a cell and the inserted Data Validation list with the following values

    - Duplicate
    - Unique

    Can I like this cell to the conditional formatting rules, so if user select Duplicate then it will execute the first formula and if the user selected unique then it will execute the second formula?
    Please see attached file for more info. Thank you very much
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 10-12-2020, 05:51 PM
  2. [SOLVED] Conditional formatting to find and highlight duplicate number
    By rizmomin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2018, 10:15 PM
  3. Replies: 2
    Last Post: 02-14-2017, 04:00 PM
  4. [SOLVED] Conditional Formatting highlight duplicate values IF cell doesn't start with "XX"
    By deneh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-16-2015, 04:44 AM
  5. Replies: 1
    Last Post: 08-18-2010, 02:00 PM
  6. Conditional formatting to highlight duplicate entries
    By legendkiller420 in forum Excel General
    Replies: 1
    Last Post: 07-12-2010, 11:36 AM
  7. Conditional Formatting- Highlight Duplicate Values
    By Christopher_1 in forum Excel General
    Replies: 4
    Last Post: 04-21-2010, 11:02 AM

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