Conditional Formatting based on range of values

[EMcK01]

Hi,

this might be really straightforward but can't seem to find it.

I want to apply formatting to a range cells if they match any cell within another range. ie apple and orange occur in column A and column B so would like only these two cells in column B highlighted.
Making the rule apply to a range of cells should be fine, how do I get it to be based on a range of values rather than just one single cell?

A	B
apple	strawberry
banana	apple
pear	peach
orange	coconut
kiwi	orange

Thanks

 

[Fluff]

How about

+Fluff New.xlsm
	A	B
1
2	apple	strawberry
3	banana	apple
4	pear	peach
5	orange	coconut
6	kiwi	orange
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B6	Expression	=MATCH(B2,$A$2:$A$6,0)	text	NO

 

[EMcK01]

Thanks Fluff, thats worked perfectly for me. Appreciate the help.

 

[Fluff]

Glad to help & thanks for the feedback.