Question: how to highlight differences in columns?
Answer: If you have some values in two columns, and now, you want to compare them row by row to highlight the differences as following screenshot shown. ...  Select the data that you want to compare two columns and highlight the differences, and then click Home > Find & Select > Go To Special, see screenshot: