• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 73
  • Last Modified:

Excel: Comparing the Values in One Column with the Values in Another

Hello:

In an Excel spreadsheet, let's say that Column A has values filled within rows 2 - 100.

Also, let's say that Column B has values filled within rows 2 - 48.  Some of the values in Column B match those within Column A, but some do not.

How can I highlight the values in Column A that match values in Column B?

Thank you!

John
0
John Ellis
Asked:
John Ellis
1 Solution
 
Rgonzo1971Commented:
HI,

You could use conditional formatting with formula

=MATCH(A2,$B:$B,0)

Open in new window

Regards
0
 
NorieCommented:
John

Select the data in column A, goto Conditional formatting>New Rule... and select Use formula to determine which cells to format.

Enter this formula,

=NOT(ISERROR(MATCH($A2, $B$2:$B$48, 0)))

then goto Format... and select the formatting you want to highlight matches.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now