Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
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.
If you’d like to read the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/tips/compare-sheets-duplicates


Related Videos:

Conditional Formatting Rows Based on Another Cell Value: https://www.youtube.com/watch?v=YAzK9vHa178&t=201s

Conditional Formatting for a List of Partial Matches in Excel:
https://www.youtube.com/watch?v=m9z2TJnYWNs

Highlight Rows Between Two Dates with Conditional Formatting in Excel: https://www.youtube.com/watch?v=-dX-njUhiMU&list=PLKbOx3gUV_E86g1Qj6Qz-9LYzQZrQ-EIl

Apply Conditional Formatting to Shapes in Excel: https://www.youtube.com/watch?v=o24yr9Oc7l0&t=4s


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