• 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.

Check for Duplicates in more than 2 sheets

Status
Not open for further replies.
S

shezi

New Member
Hello,

I have a column with Company Names in sheet1 and I will have the same column in other sheets.
I would like for the Company Names highlighted in color if it has been entered in one of the other sheets before.
I want all the sheets to have the duplicates highlighted in color whenever a company name has been found in another sheet.
Please note that there can will be around 10 to 15 sheets.

Is there any such formula that I can add in the "New Rule" of conditional formatting?

Here is a screenshot of what the sheets will look like:

80471
 
shezi
Why did You duplicate Your thread?

Compare two or more sheets for duplicates with Conditional Formatting

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...
chandoo.org
You should continue add more details in Your original thread.
This thread is closed.
 
Status
Not open for further replies.
Back
Top