Highlight duplicates in range of cells

Posted on 2011-04-24
Last Modified: 2012-05-11
Columns C, D, and E contain stock symbols.  I want to "highlight only" any duplicates that exist anywhere in that range of cells, regardless of where the duplicate appears.  Assistance is greatly appreciated.

Question by:rtod2
    1 Comment
    LVL 22

    Accepted Solution

    How about applying the following conditional formatting to cell C3:


    and show the text in Red (or whatever you like)

    Then Copy cell C3 and Paste-Special | Format into the remaining cells from C:E

    Attached is an updated version (although I updated in 2007 so I'm not sure if it will load properly in 2003.)

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now