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:
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:
Last edited: