Channel: Excel Campus - Jon

Category: Education

Tags: excelduplicatesconditional formattingworksheetstwo sheets for duplicates with conditional formattinghighlight duplicatescompare two sheets in excel for duplicatesexcel campuscompare two sheets in excelcompare two listscompare two lists in excel for matchesduplicate values

Description: 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: excelcampus.com/tips/compare-sheets-duplicates Related Videos: Conditional Formatting Rows Based on Another Cell Value: youtube.com/watch?v=YAzK9vHa178&t=201s Conditional Formatting for a List of Partial Matches in Excel: youtube.com/watch?v=m9z2TJnYWNs Highlight Rows Between Two Dates with Conditional Formatting in Excel: youtube.com/watch?v=-dX-njUhiMU&list=PLKbOx3gUV_E86g1Qj6Qz-9LYzQZrQ-EIl Apply Conditional Formatting to Shapes in Excel: youtube.com/watch?v=o24yr9Oc7l0&t=4s #MsExcel #ExcelCampus