Using Conditional Formatting to highlight one of a list of values

[steveh8204]

What is the easiest way to use Conditional Formatting to highlight any value in a designated column (B for example) in a table that is equal to one of various values from another table.

For example, in Sheet1 if there was a table of first names how would I highlight one if it equalled one of 5 names in a separate table on Sheet2 (which would just be a table of qualifying names)? And, ideally, how would I highlight the whole row not just the cell?

Thanks in advance for any help!

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H
1	Name	Owner						Names
2	Tom Pearce	Owner1						Peter Davy
3	Bill Brewer	Owner2						Harry Hawke
4	Jan Stewer	Owner3						Bill Brewer
5	Peter Gurney	Owner4
6	Peter Davy	Owner5
7	Dan'l Whiddon	Owner6
8	Harry Hawke	Owner7
9	Tom Cobley	Owner8
10
11
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B9	Expression	=MATCH($A2,$H$2:$H$4,0)	text	NO

 

[AlanY]

like this?

Book1
	A	B	C	D	E	F	G	H	I
1	Name1
2	Name2
3	Name3
4	Name4
5	Name5
6	Name6
7	Name7
8	Name8
9	Name9
10	Name10
11
12
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
1:13	Expression	=COUNTIF(Sheet2!$A:$A,$A1)>=1	text	NO

Book1
	A	B	C	D
1	Name2
2	Name4
3	Name6
4	Name8
5	Name10
6	Name12
7	Name14
8	Name16
9	Name18
10	Name20
11
Sheet2

 

[steveh8204]

Perfect! both just what I need, thanks for the quick replies, much appreciated!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[AlanY]

Perfect! both just what I need, thanks for the quick replies, much appreciated!

you're welcome