Compare Two Sheets for Duplicates with Conditional Formatting

In this video, I demonstrate how to compare two worksheets and use conditional formatting to highlight entries that are found in both. Cells that have multiple duplicates can be formatted differently to stand out.

Related Videos:

Conditional Formatting for a List of Partial Matches in Excel:

#MsExcel #ExcelCampus
00:00 Introduction
01:08 Conditional Formatting
03:05 Apply Conditional Formatting
04:48 Important Notes

[acho]

Hey dude, yesterday, it took me a bit to get the results, probably because I was stressed out and in a rush but, today in the morning, Saturday, relaxed and after a cup of coffee I was able to do what I wanted to do. Get duplicated IDs from a list of 19, 332 users. In a couple of minutes, I finally was able to accomplish my goal.. thank you so much! you got my subscription for more, the review, and the like... good explanation, calmed, good tone, friendly, and straight to the point.. thanks

[SalikKhatri]

Your delivery is precise, concise and very easy to follow. Gret work John!

[liene]

I appreciate how you explain everything in a simple way, making it very straightforward!

[crissavillarosa]

I've already finished 15 different videos, this one really helps me the most! thank you mister

[DavenportDecals]

Thank you so much... just spent about an hour trying to find how to do this. Your instructions are clear and easy to follow.

[darrylmorgan]

Great Tutorial And Explanation For Duplicates Using Conditional Formatting...Thank You Jon :)

[bobdunyak]

Thank you for the clear, concise video. I was able to apply your instructions to my sheet. I appreciate you taking the time to help others.

[niafporter]

Thanks Jon! You just helped me create a really important report for work with this easy to follow video!

[petecardona]

Awesome explanation professor. Always clear to understand.

[mohamedmarzouk]

Thank you man, i was searching a lot for this formula ❤️

[KM-comx]

This was great. Thank you!
The explanation about the relative reference in Conditional Formatting was very useful.

[christinet]

Thank you so much! This was incredibly helpful. You must be a teacher. I know nothing about formulas and didn't really understand the "True" and "false" and some other references you made, but I was successful in comparing my 2 sheets!

[jaychauhan]

thanks man found soultion of my error in just under 3 mins of your video

[catherinevega]

This was extreemely clear and useful! Thank you!

[Princess_Slaya]

Thank you for your detailed explanation! You’ve made it very easy to understand :)

[AbdifatahHassan-np]

Before more Vedio, final i find this great opportunity thanks 🎉🎉🎉❤

[salmaalaa]

The best person .that who help another person

[EnaanFarhan-kd]

Thanks for your amazing tutorial video.

[Gabbieesque]

Wow! Thank you! SOOO helpful. You just saved me so much time.

[chriswebb]

Thanks for this useful info. How do you configure this if you have a column of extension on 3 worksheets?