How to Match Two Columns Microsoft Excel
- George Apostolov
- 05 Sep 2025
Guide
Select the column you want to compare.
Go to "Home" > "Conditional Formatting" > "New Rule."
Choose "Use a formula to determine which cells to format."
Enter the formula
=COUNTIF($A:$A, C2)>0, adjusting for your columns.Set the format (e.g., change the fill color to blue), then click "OK".
Matching cells will be highlighted in blue.
Create your first interactive demo in minutes
No credit card required • Start building today
