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

Видео Compare Two Sheets for Duplicates with Conditional Formatting канала Excel Campus - Jon