How to Compare Two Columns in Microsoft Excel
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.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it