How to compare two columns in Excel
- Select the specific column
- Navigate to Home- Conditional Formatting
- Select New Rule
- Select the option ” Use a formula which cells to format
- Add the formula =countif($B:$B, $A1)
- Navigate to Format Cells and select Fill
- Select any colour to differentiate the results
- Now the matching values will have the selected colour
Tech Ripples 