Excel - Conditional Formatting find duplicates on two worksheets by Chris Menard

Finding duplicates with Conditional Formatting in Excel is easy when the data is on the same worksheet.

When the information is on two worksheets, you have to write a formula and use the CountIF function.




And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[rowanwhistler]

Mr. Menard, you just saved me a full day of work. For that, I am thankful.

[Bikinigirl]

Thank you so much. You saved me from a big

[cldaughe]

I know this video is a couple years old, but it is still SO RELEVANT! I had two sheets with over 2000 rows of data and I needed to find like numbers by comparing both sheets. This formula WORKS!!! :) :) :) Thank you!!!

[lucindarutherford]

This was way quicker than any other videos I've looked at . Thank you

[AhmedMohamed-thym]

Thank You Chirs, You couldn't imagine how this tutorial helped me and saved my time.

[spye]

Thank you so much for this. I did have to watch the video twice and try the formula three times - but 10 minutes later you had saved me hours and hours of work. I really appreciate this video!

[shannonxueping]

I spent the last 2 hours trying this and replaying this video and thank god I have finally made it!!!
I'm so glad that I found this video - i'm looking for duplicates between two spreadsheet that could that me days or even weeks to complete!
This is just life-saving!!

[thewayfarer]

Wow. Yesterday I spent well over an hour searching for how to do this. I kept going down all these rabbit holes that led me to nowhere but frustration. Found this video today on my second try and in less than four minutes I’m a wizard! Thank you so much for this, Chris!

[francesstockwell]

Thanks so much for this video. I am an Executive Assistant and this saved me a lot of time on a task a client sent me.

[judiburns]

Thank you Chris! Exactly what I needed in a pinch. Lifesaver!

[knightbrown]

This video is the best explanation of how to compare two sheets and find duplicates with highlighting formats, congrats!!!

[realp.]

I've watched a few videos on this, wish I would have landed here first, thanks Chris!

[DunBeezyify]

Whenever I have an Excel problem I always search your channel. Appreciate the clear instructions. Miles better than any other instructions. Thanks Chris!

[ImOnlyJustKidding]

Thank you for making this wonderful video

[catnaps]

Such a helpful video when dealing with thousands of rows. Thank you :-)

[henryetienne]

This video saved me so much time and work. Thank you

[lawalhabeebat]

Thank you so much for sharing. You just saved me several hours of work

[marissaberardinelli]

Hi! I just wanted to say this is EXACTLY what I was looking for. I could not remember how to from school and needed the formula for work. Life saver :)

[GGruba]

Thank you for this tutorial. Saved me hours of work.

[aryansen]

Absolute life-saving trick.... Thank you so much, Chris.