# 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.