How to Compare Two Lists in Microsoft Excel
Microsoft Excel offers two different methods to help you compare two lists and highlight the missing items in each one. You can choose to highlight the missing items in both lists or in a single one. We’ll show you how.
Microsoft Excel Difference Between Values Quick Way Highlight Unique Cells Conditional Formatting Highlight Cells Rules
Source: howtogeek.com