Conditional Formatting

Sheridi

New Member
Joined
Nov 20, 2015
Messages
49
I have a worksheet that contains last names in cells A1:D10 (all unique).

I have named a range (Qs) in the same workbook and that range contains 3 names in cells a1:a3 -

Jones
Smith
Riley

Is there a conditional formatting formula that will format any of the cells in A1:D10 where the last name is contained in the range Qs (Jones or Smith or Riley)?

Thanks for your help.
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

arthurbr

Well-known Member
Joined
Dec 8, 2006
Messages
2,075
Office Version
  1. 2010
So the names to find are in A1:A3 and the range containing them is A1:D10 ? The first is thus part of the second? Are they on the same sheet?
 

Sheridi

New Member
Joined
Nov 20, 2015
Messages
49
Sorry I did not make that clear. The names to find are on a separate worksheet in the same workbook.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,010
Office Version
  1. 365
Platform
  1. Windows
How about
=ISNUMBER(MATCH($A1,Qs,0))
 

Watch MrExcel Video

Forum statistics

Threads
1,108,501
Messages
5,523,292
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top