You can also select custom format here to manually select a background fill and font styles.

This feature is only available on Excels desktop version, and the mobile app doesnt support it.

Find the spreadsheet file with the lists you want to compare, and double-click the file to open it in Microsoft Excel.

Click the first cell on your first list, and drag your mouse all the way down to the lists last cell to select the entire data range.

You can find this tab above the toolbar at the top of your spreadsheet.

You can find this option in the middle of the Formulas ribbon.

It will open a new pop-up window, and allow you to name your list.

Click the text field at the top of the pop-up window, and enter a list name here.

For example, if this is a list of locations, you can name it locations1 or locationList.

Follow the same steps as the first list, and give your second list a name.

This will allow you to quickly use this second list in your comparison formula later.

Make sure to remember or note down the name you give to each of your lists here.

This is the first tab in the upper-left corner of the toolbar ribbon.

This option looks like a tiny spreadsheet icon with some cells highlighted in red and blue.

It will open a drop-down menu of all your formatting options.

This option will allow you to manually type a formatting formula to compare your two lists.

Then, find this option in the second drop-down below the Style menu.

You can enter any valid Excel formula here to set up a conditional formatting rule.

This formula will scan your two lists, and mark all the cells on your first list that also appear on the second list.

If you want to find and mark the cells on your second list that also appear on the first list, use this formula instead of the first one.

You can select a custom background fill color and different font styles to mark the cells that your formula finds.

You can select a background color in the Fill tab, and font styles in the Font tab.

How To Compare 2 Columns In Excel For Matches And Differences Mac