Comparing workbooks and highlighting matching data

[pelachrum]

Hi,
I need to compare values in two separate workbooks (I can also just compare two Sheets if that's easier to do that way) .

Wb A has values in column A, Wb B has values in column B. Some of these values correspond to each other, i.e. they're identical (We're talking plain string of numbers but the column is of General category).

Can I somehow run a preprogrammed search on Wb A that compares it to Wb B, column B and highlights the values (in Wb A) that match exactly anything found in Wb B?

[pelachrum]

I found this macro that does similar job but prints matching values into another cell instead. I'm guessing it's the part in red that needs to read "highlight value X in whatever color" ? What's the VBA syntax for that?

Please Login or Register  to view this content.

[pelachrum]

I found the answer:

Please Login or Register  to view this content.