Guide

1. Inside your Microsoft Excel worksheet, find and select the two columns you wish to compare.

2. After that, select 'Conditional Formatting' from the available options under the Home tab.

3. Hover your mouse cursor over the 'Highlight Cell Rules' and then choose 'Duplicate Values'.

4. Following that, click the drop-down menu right below the 'Highlight Cells With' section and choose your preferred condition.

5. Go over the provided options for 'Format Style' and choose one that suits your liking.

6. Subsequently, tap 'Done' to proceed.

7. 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.