How to compare Microsoft Excel columns with conditional formatting Use conditional formatting to highlight column and row differences with colors or other formatting options.