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.