How to Match Two Columns Microsoft Excel

Author

• George Apostolov
• 05 Sep 2025

Guide

1. Select the column you want to compare.
2. Go to "Home" > "Conditional Formatting" > "New Rule."
3. Choose "Use a formula to determine which cells to format."
4. Enter the formula =COUNTIF($A:$A, C2)>0, adjusting for your columns.
5. Set the format (e.g., change the fill color to blue), then click "OK".
6. Matching cells will be highlighted in blue.