Excel: Compare 4 Columns of Data
I Have a File That I Need to Compare 4 Columns of Data. the Data Is Clients' Names Pulled from Two Different Systems. How Do I Get Excel to Only Highlight...
I have a file that I need to compare 4 columns of data. The data is clients' names pulled from two different systems. How do I get excel to only highlight those rows where First Name 1 matches First Name 2 AND Last Name 1 matches Last Name 2?
1 Answer
Use Conditional Formatting
- Select your entire data (not including your headers)
- Click on Conditional Formatting on the Home ribbon
- New Rule > Use a formula to determine which cells
- Enter
=$A2&$B2=$C2&$D2as the formula - Choose the desired format for matching records (row highlights are under the 'Fill' tab)
- Click OK
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
