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.
chrismenardtraining.com
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ CZcams keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
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!

[@shannonxueping9493]

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!!

[@rowanwhistler]

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

[@ChrisMenardTraining]

Daniel, glad to help.

[@inekeabunawass5641]

Me too. That was great!

[@procrastinatelata17]

Thank you for your time and enjoy your Sunday also.

[@ginnyhara]

Chris, thanks so much for sharing this. A true lifesaver for a project I was doing.

[@spye007]

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!

[@ChrisMenardTraining]

Glad to help. Thank you, Susan.

[@despinoza0391]

This saved me so much time! Your instructions were clear and easy to follow. Thank you!

[@AhmedMohamed-th2ym]

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

[@beata911]

Thank you, Chris, it was just what I was looking for! And it saved me many hours of work checking them manually :)

[@ChrisMenardTraining]

Glad to help.

[@knightbrown7]

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

[@DunBeezyify]

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

[@judiburns4392]

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

[@ChrisMenardTraining]

Glad it helped!

[@marissaberardinelli9884]

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 :)

[@ChrisMenardTraining]

Glad it was helpful!

[@judithmacneil6129]

Excellent tutorial, Chris. Very practical and to the point. I had tried three others before finding yours. Thanks so much. Subscribed.

[@ChrisMenardTraining]

Thank you Judith.

[@OpaqueDragon4]

Thank you for this tutorial! This saved me a lot of time and energy at work today. Much appreciated!

[@ChrisMenardTraining]

You're very welcome!

[@christinegoodale7961]

Nicely explained! My lists were on two separate workbooks so I just had to copy one as a second worksheet on the first workbook and it worked out great. Thank you!

[@ChrisMenardTraining]

Glad it worked. Thank you.

[@lucindarutherford3933]

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

[@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!!!

[@ChrisMenardTraining]

Great to hear! Thanks, Christina!

[@aldenbayless7954]

2 more years on top of your 2 years and still relevant!

[@aryansen8694]

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

[@ChrisMenardTraining]

You are welcome.

[@guruprasath3097]

Thanks for the video. . It's working with multiple criteria's as well using countifs

[@ChrisMenardTraining]

Excellent!

[@5280CraftSupply]

Awesome video. Easy to follow and exactly what I wanted. Thank you!

[@ChrisMenardTraining]

Vanessa, I appreciate the positive feedback. Have a beautiful day.

[@tacijjola]

Very helpful and clear! Thanx very much!

[@lifescience8824]

Thank you, Chris. Very precise and to the point. I really Appreciate it!

[@ChrisMenardTraining]

You are welcome.

[@thewayfarer1337]

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!

[@ChrisMenardTraining]

You're very welcome!

[@nycollassilva3558]

@@ChrisMenardTraining sjscfq1clhfkv

[@yasminapd95]

Brilliant, just what I was looking for. Thank you so much!

[@ChrisMenardTraining]

Glad it was helpful!

[@hachvana]

Thank you Chris! This video was really helpful!

[@ChrisMenardTraining]

Glad it was helpful!

[@ImOnlyJustKidding]

Thank you for making this wonderful video

[@ChrisMenardTraining]

It's my pleasure

[@josephhartzell1077]

I searched for hours before I found your video, thank you so much for making this so simple and clear.

[@francesstockwell3309]

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.

[@ChrisMenardTraining]

Glad to help. I do a lot of training for Executive Assistants through the American Society of Administrative Professionals. Thanks, Frances.

[@hobrandon]

Amazing, clear and concise tutorial. Thank you!

[@ChrisMenardTraining]

You're very welcome!

[@WellEveSays]

You are a life saver! Thank you for making this simple to follow video tutorial.

[@ChrisMenardTraining]

You're welcome!

[@liranmayouhas6724]

Perfect. Worked like a charm

[@user-ke2sw1sn6b]

Thank you so much! Easy and direct to the point.

[@ChrisMenardTraining]

You're welcome!

[@louiscowell4003]

This is great, thanks, Chris

[@KB-oc5ux]

Thank you so much for this video Chris!!

[@ChrisMenardTraining]

Glad to help.

[@TikiJawa]

Thanks for posting this,very helpful!

[@ChrisMenardTraining]

Jason, I'm glad you liked it. Thank you for the positive feedback.

[@greenville4142]

That was exactly I wanted! So helpful, thank you.

[@ChrisMenardTraining]

You're so welcome!

[@RS-xh4yk]

This worked for me. Thank you!

[@user-xr4yl9ie1s]

Thank you! The only video I have followed and it worked! Super clear :)

[@nicshoffner3131]

Thanks for this tutorial. It was exactly what I needed.

[@ChrisMenardTraining]

You're welcome!

[@GGruba]

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

[@ChrisMenardTraining]

Great to hear!

[@mclarensmps]

Appreciate this video so much, thank you Chris! Helped me out immensely

[@ChrisMenardTraining]

Glad to hear it!

[@realp.1700]

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

[@ChrisMenardTraining]

No worries! You found me at least! :-)

[@edwardlekson1862]

Excellent - thanks Chris!

[@ChrisMenardTraining]

My pleasure!

[@jayedesaree]

This video was very helpful. Thank You!

[@ChrisMenardTraining]

You're welcome!

[@alycouris]

this was exactly what I was looking for! thanks!

[@ChrisMenardTraining]

Thank you for the positive feedback. Have a good weekend.

[@safetytalkbytoveleeds9822]

Many Thanks, Extremely thankful

[@ChrisMenardTraining]

Thank you.

[@prafulsal4565]

To the point..excellent..Keep up the good work!!

[@ChrisMenardTraining]

Thanks, will do!

[@CrazyAmbitious11]

God bless you man!

[@princessofJesus777]

This is awesome! Thank you!

[@ChrisMenardTraining]

You're very welcome!

[@Bikinigirl05]

Thank you so much. You saved me from a big one!!!!!!

[@ChrisMenardTraining]

glad to help

[@henryetienne4518]

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

[@ChrisMenardTraining]

You're welcome!

[@jsjooste]

Tip top! Much appreciated Sir.

[@ChrisMenardTraining]

Glad to help. Thank you.

[@user-jf2hh2bo2b]

Thank you, Its really helped❤❤

[@catnaps19]

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

[@ChrisMenardTraining]

Thanks, Cath.

[@J8kpin]

Thank you so much this was a lifesaver

[@ChrisMenardTraining]

You're welcome!

[@rahullahiri3380]

Very helpful! Thank you!

[@ChrisMenardTraining]

You're welcome!

[@iWorshipLyrics]

This is really helpful. Thanks for sharing

[@ChrisMenardTraining]

You're so welcome!

[@gary4829]

Very well done...thanks!

[@ChrisMenardTraining]

I appreciate it.

[@keishabridges3442]

Thanks for sharing. Gonna give this a try on my project tomorrow

[@ChrisMenardTraining]

Thank you. Good luck on your project.

[@shahriarparvez4500]

Thanks, It is helpful.

[@Razz1410]

Thank you for posting this video.

[@ChrisMenardTraining]

You're welcome

[@izzatJJ9988]

Thank you so much sir. Your video easy to understand and not complicated.

[@ChrisMenardTraining]

You are most welcome

[@pamshinesday1381]

saving my time a lot thank you

[@ChrisMenardTraining]

Welcome

[@lawalhabeebat5764]

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

[@ChrisMenardTraining]

You are welcome!

[@anusreegopalakrishnan]

Thank you. Very helpful

[@ChrisMenardTraining]

You're welcome!

[@tresa1001]

Thank you! Perfect!

[@ChrisMenardTraining]

You're welcome!

[@cindylove7727]

Thank you!!!! You are a lif saver.

[@ChrisMenardTraining]

Happy to help!

[@Oobi666]

you are a wizard sir
thank you so much i was comparing inventory over several locatoins
and i think this just saved me hours and hours of time

[@ChrisMenardTraining]

Glad it helped

[@ahsanbaig74]

great Chris !

[@ChrisMenardTraining]

You are welcome.

[@user-ws7mn5nw3e]

realy cool trick chris.thanks a lot.

[@ChrisMenardTraining]

Glad you liked it!

[@WrinkleRelease]

Exactly what I was needing.

[@ChrisMenardTraining]

Thank you.

[@j0eyyl0ve]

thank you so much!

[@diggzz222]

Hi... How do you handle more than two worksheets? Is it the same process?

[@sankarbiswas5945]

Thanks for the idea. I was able to write my custom formula using this.

[@ChrisMenardTraining]

Glad it helped!

[@Ferienpapst]

Thank you sir!

[@ChrisMenardTraining]

You are welcome!

[@ishararathnayake6159]

Thanks Chris

[@ChrisMenardTraining]

You are welcome

[@haiyennguyen7635]

Awesome, thank you so muchhhhh

[@ChrisMenardTraining]

You're welcome!

[@riteshvedi7845]

Thanks a lot sir for making such a good video it is really help

[@ChrisMenardTraining]

Most welcome

[@sitifatihasholehudin7357]

tq sir...u do help me on this...as a beginner...tqsm

[@ChrisMenardTraining]

Most welcome!

[@juliezepeda5716]

Thank you!

[@ChrisMenardTraining]

You're welcome!

[@gwladysmorrissey4679]

Thanks this helped me so much!

[@ChrisMenardTraining]

Glad it helped!

[@gwladysmorrissey4679]

@@ChrisMenardTraining Is there a way to do this with near matches?

[@harisqureshi1554]

Thankx Chris

[@ChrisMenardTraining]

You're welcome.

[@jagannathdas749]

Thank you.

[@ChrisMenardTraining]

You're welcome!

[@ahmedrafaat1179]

Thank you

[@ChrisMenardTraining]

You're welcome

[@Anshu601]

Worked for me❤

[@ChrisMenardTraining]

Good to know. Thank you.

[@bknight786]

Thanks!

[@ChrisMenardTraining]

Thank you. Much appreciated.

[@yourface2616]

Thank you sir

[@ChrisMenardTraining]

Welcome

[@folksy3215]

Thankyouuu very much sir

[@ChrisMenardTraining]

Most welcome

[@mohamedmagdy8683]

I Love You thanks alot

[@ChrisMenardTraining]

Glad to help.

[@marwanmohammed4451]

Thanks

[@janetcourville3339]

I have a workbook that I add sheets to each week. I need any duplicate data (range would be every existing worksheet in the book) to be apparent when entering the information in the new week's sheet. How do I do this? Is it possible?

[@curleyleehorton252]

What if I want the entire row highlighted.

[@dennischua193]

what if there are three (3) worksheets to compare?

[@marvenscantave4023]

This was a wonderful video, thank youfor it. is there a way to have it delete the duplicate instead of highlighting it?

[@MohdIqbal-xs4ur]

Awesome

[@ChrisMenardTraining]

Thank you!

[@williammackenzie2926]

Chris, How do I look for values that are Non Duplicates on two different worksheets using similar countif formula?

[@Rewear_Revolution]

Super helpful!!!! I'm noticing it did not catch some of my duplicates though and I'm wondering what might have caused this? I still have to manually check my lists so that's how I figured it out. Thoughts?

[@muhammadsyafiqhaslan3117]

how do we check duplicates on multiple worksheet(more than 2)?

[@Feastthailand]

This was great to find, just not exactly what I am after and I wonder if you have any idea to achieve what I need. I have 11 sheets in a file and want to copy and paste any duplicate data in 10 of the sheets to an 11th sheet. To check for duplicates, columns A, B & H are required, so if A, B & H match in more than 1 sheet, the data in that row is copied to the next available row in the 11th sheet. Is this achievable at all using COUNTIF or another function for that matter? Thanks so much

[@hparis9462]

THANK YOU! Oh my goodness, running reports for work and i've spent the last 2 hrs trying to figure this out so I can eliminate extra daily work! This was so easy to follow!

[@ChrisMenardTraining]

Glad to help.