It is very easy to compare two columns in Microsoft Excel via the Conditional Formatting function. Here’s a quick guide on how to do it:
- Inside your Microsoft Excel worksheet, find and select the two columns you wish to compare.
- After that, select 'Conditional Formatting' from the available options under the Home tab.
- Hover your mouse cursor over the 'Highlight Cell Rules' and then choose 'Duplicate Values'.
- Following that, click the drop-down menu right below the 'Highlight Cells With' section and choose your preferred condition.
- Go over the provided options for 'Format Style' and choose one that suits your liking.
- Subsequently, tap 'Done' to proceed.
- After completing these steps, the cells will be highlighted based on your input. You can use them as your guide while comparing the two selected columns.
