• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Compare two or more sheets for duplicates with Conditional Formatting

shezi

New Member
Hello,

I have a column with Company Names in sheet1 and I will have the same column in other sheets as well for example sheet2. I would like for the Company name highlighted in color if it has been entered in one of the other sheets before. I want all the sheets to have the duplicates colored whenever a company name has been found in another sheet. There will be more than 2 sheets.

Side note: In sheet 1 I created a duplicate column and used a COUNTIF formula to indicate which companies are duplicates.

Here is my sample file:
 

Attachments

  • Tracking.xlsx
    21.8 KB · Views: 9
Last edited:
Back
Top