However, you can also use conditional formatting to compare two columns in Excel. Here's how: Once you're done comparing the data, you can remove the conditional formatting by going to Conditional ...