However, you can also use conditional formatting to compare two columns in Excel. Here's how: Open the Excel spreadsheet containing the columns you want to compare.