Whether you're comparing a single list or several, Excel's conditional formatting can get the job done.

Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.

How to use Excel formulas to compare multi-column lists Your email has been sent Duplicates in the same column are easy to find by sorting, filtering, and using conditional formatting. When none ...