Question: how to compare two cells in excel and highlight differences?
Answer: Select the entire data set. Click the Home tab. In the Styles group, click on the 'Conditional Formatting' option. Hover the cursor on the Highlight Cell Rules option. Click on Duplicate Values. In the Duplicate Values dialog box, make sure 'Duplicate' is selected.