Question: how to highlight differences between two sheets in excel?
Answer: Enable the workbook you want to compare two sheets within, and then click View > New Window. Then go to the task bar to display the new window of the current workbook. ...  Go to the two sheets you want to compare from each window and arrange them side by side.