compare two lists for matches excel 2016 mac

First, select the data range that you wish to highlight from two columns.

In cell C2, there is no match so nothing will appear if we drag down the cell where the two rows match there we will found our result.Īgain, conditional formatting can be used for finding the matches between two columns in Excel.

Then use the formula =IF(A3=B3,'Match','').

Let’s select the cell C6 for applying the formula.

As you can see there is a match in cells A6 and B6.Here we will be using it to find the matches in two columns. IF function plays a significant role in finding both differences and matches in excel. A new dialogue box of Format Cells will come up, please specify a color of your choice for highlighting the differences under the Fill tab.Ĭompare two lists in excel and highlight matches 1) Using the Match function.Enter this formula: =$A3$B3 into the Format values where this formula is true text box and then press on to the Format option.Click Use a formula to determine which cells to format under the Select a Rule Type list box.Then click on to New Rule from Conditional Formatting option from your Home tab.At first, select the data range that you wish to highlight from two columns.Using conditional formatting is a way of finding the differences between two columns in Excel. Further Readings Compare two columns in excel and highlight differences

Compare two lists for matches excel 2016 mac