Need to find duplicates across three columns

[lost&found]

Hi there,

I have three columns of data. My need is to find the data that matches across all three columns (regardless of row number) and have it highlight. I have been able to get my macro to work comparing the data in two of the three columns, but when I add the thrird it, it will run but not return any results.

Here is what I have:

Please Login or Register  to view this content.

I have searched for a solution everywhere I can think of for a month and have had little in the way of helpful results. Any help you can provide would be greatly appreciated.

Thank you!

[AlphaFrog]

If I understand correctly what you want to do, try this...

Please Login or Register  to view this content.

[lost&found]

Thanks for the help AlphaFrog, however that didn't quite do what I need. I tried your solution, and it looks like it matched two of the columns data and turned them green instead of doing a three way match.

I only want the cells to turn green if the same value is found in all three columns.

[AlphaFrog]

Thanks for the help AlphaFrog, however that didn't quite do what I need. I tried your solution, and it looks like it matched two of the columns data and turned them green instead of doing a three way match.

I only want the cells to turn green if the same value is found in all three columns.

So you want to find triplicates across three columns.

Change the three Ors to Ands

Please Login or Register  to view this content.

[lost&found]

Correct, sorry my wording was off. I should have caught that, no wonder I couldn't find a solution .

Your suggestion worked perfect. Thank you so much for all your help. I ran the code and it does exactly what I need it to do!

Thank you again!