+ Reply to Thread
Results 1 to 2 of 2

How to highlight the Duplicate values in a column

Hybrid View

  1. 10-26-2013, 02:31 PM #1
    BRout
    BRout is offline
    Registered User
    Join Date
    01-06-2013
    Location
    India
    MS-Off Ver
    Excel 2003,2007
    Posts
    31

    How to highlight the Duplicate values in a column

    Hi all,

    Please find the attached Sheet, where some values are entered in column A with repeated action. What I need that through an excel function the repeated values should get red colour like in the Column C.


    Thanks in Advance.....



    Bikash
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-26-2013, 02:44 PM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to highlight the Duplicate values in a column

    Select column then: Go to Conditional Formatting and click Highlight Cells Value rules and select Duplicate Values.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare then highlight duplicate values
    By Hurricanefly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2015, 04:57 PM
  2. Highlight duplicate values
    By abibayley in forum Excel General
    Replies: 3
    Last Post: 04-23-2012, 12:03 PM
  3. Need help on how to highlight duplicate values
    By avadakedava in forum Excel General
    Replies: 3
    Last Post: 04-10-2012, 11:27 AM
  4. Highlight duplicate row values
    By Brian Tam in forum Excel General
    Replies: 5
    Last Post: 08-27-2010, 04:54 PM
  5. [SOLVED] Highlight Duplicate Values in a Range
    By Paul D. Simon in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2006, 07:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1