Click on the Format button and specify the format you want to set. =countif($B:$B, $A1) Enter the formula provided in the text boxĦ. Proceed by entering the following formula in the ‘ Format values where this formula is true‘ box: Select the ‘Use a formula to determine which cells to format’ optionĥ. Select ‘ Use a formula to determine which cells to format‘ as a rule in the New Formatting Rule window. Select New Rule from the Conditional Formatting drop-down listĤ. Select the New Rule option from the Conditional Formatting button drop-down list. Select the Conditional Formatting button under the Home tabģ. Select the Conditional Formatting button on the Home tab. Highlight column A by clicking the column headerĢ. Click on the Column Header to highlight Column A.

In this tutorial I will show you how to compare two columns in Excel so that the values that appear in both columns become highlighted and you can do something with those duplicate values.