Conditional Formatting - highlight duplicates across 3 worksheets in the same workbook

[jerryroller]

I am trying to use Conditional Formatting to highlight duplicates across 3 worksheets within the same workbook. Is there a way to EASILY do this? Please advise. Thank you!

 

[DanteAmor]

Review this:

https://www.mrexcel.com/forum/excel-questions/1095652-conditional-formatting-one-cell-column.html

 

[jerryroller]

Review this:

https://www.mrexcel.com/forum/excel-questions/1095652-conditional-formatting-one-cell-column.html

Wow. Did you even bother to READ my post???

 

[DanteAmor]

Wow. Did you even bother to READ my post???

Do not be angry, we just try to help.
In the link are examples of how to identify a value repeated on another sheet.


If you want, we start with that.


If you want, you can be more specific, in which sheet and in which column you will capture data.
What is the name of the other 3 sheets?
In which column in the other 3 sheets you want to review.


Or if you prefer, upload a file with some examples and I will gladly review it.

You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

If it is not so simple what you ask then it should be with a macro, check the following:


https://www.mrexcel.com/forum/excel...ing-duplicate-data-multisheet-workbook-3.html

 

[DanteAmor]

Write a number in column A on the Test sheet.
If the number exists in sheets 1,2 or 3, it will be highlight yellow.

Check my file test:

https://www.dropbox.com/s/7lzxbohi862anrs/conditional formating 3 sheets.xlsx?dl=0


How does it work:
1.- Select sheet1
2.- Select column A
3.- Write Column1 in the name box
4.- Press enter
5.- Repeat the steps for sheets 2 and 3, with the names Column2 and Column3
6.- Select Test sheet
7.- Select cell A1
8.- Select Menu / Format / Conditional formating / New rule / Formula

=SUM(IFERROR(MATCH($A1,column1,0),0) + IFERROR(MATCH($A1,Column2,0),0) + IFERROR(MATCH($A1,Column2,0),0)) > 0

Format: color Yellow

Applies to: =$A:$A

Let me know if you have any doubt

 

[jerryroller]

Do not be angry, we just try to help.
In the link are examples of how to identify a value repeated on another sheet.


If you want, we start with that.


If you want, you can be more specific, in which sheet and in which column you will capture data.
What is the name of the other 3 sheets?
In which column in the other 3 sheets you want to review.


Or if you prefer, upload a file with some examples and I will gladly review it.

You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

If it is not so simple what you ask then it should be with a macro, check the following:


https://www.mrexcel.com/forum/excel...ing-duplicate-data-multisheet-workbook-3.html

Not mad, just asking if you did because he link took me back to what I said did not work. Finding dupes in 1 worksheet I simple. Attempting to find dupes across separate worksheets in the same workbook is taking up way too much of my time.

 

[DanteAmor]

Not mad, just asking if you did because he link took me back to what I said did not work. Finding dupes in 1 worksheet I simple. Attempting to find dupes across separate worksheets in the same workbook is taking up way too much of my time.

You downloaded my test file There the test sheet is compared against 3 sheets.