Excel 2007 : Compare two columns and color matches

[tmikule2]

Hello!

I have problem with finding matches in two colums,
what i need is:

E.G.

i have:

Column A____Column B

John________Steve
Steve_______Mick
Freddy______Michael
Alfred
Mick

Result will be:

Column A____Column B

John________Steve
Steve_______Mick
Freddy______Michael
Alfred
Mick


Thanks

[DonkeyOte]

You can use a Conditional Formatting formula to do this, assuming your data resides in A1 onwards and list of names to match in B1 onwards, do the following:

Highlight your data in column A (selecting A1 first) -> Format -> Conditional Formatting -> FormulaIs: =ISNUMBER(MATCH($A1,$B:$B,0))
set format accordingly

[tmikule2]

I have tried but it doesn't work... Here is example what I need, and result must be that in first colum matches would be red.

[DonkeyOte]

That's probably because you didn't use the formula I gave you

Copy the formula from post # 2 and paste it directly into your conditional format formula in XL (replacing what's there already)

You should not have quotation marks around the formula... ie =ISNUMBER(...) and not "=ISNUMBER(...)"

EDIT:

Given you're operating in Croatia you may need to use

=ISNUMBER(MATCH($A1;$B:$B;0))

ie use semi colon ; rather than comma , as delimiter in the function

[tmikule2]

Thank's, it works!!!