Thanks a bunch. This works like a charm. Now to take this one step further
can I add to the formula or how do I filter out to see only the ones
identified?

"Max" wrote:

Here's a way to conditionally format it ..

Assume your list of 20 client names are in Sheet2's A1:A20

First, define a named range: SpecialClients
to refer to this list

In Sheet2,
Select A1:A20, then click inside the namebox*, key-in: SpecialClients, press
ENTER
*the box with the dropdown just to left of the formula bar

In Sheet1,
Assume source data in cols A to AA, from row 9 down,
with client names running in P9 down

Select all the 1500 rows from row 9 down
(select the row headers)

Click Format Conditional Formatting,
Under Condition 1, Formula is:
=ISNUMBER(MATCH($P9,SpecialClients,0))
Click Format Patterns Light Brown? OK
Click OK

The above will format entire rows where the client names in col P matches
those within SpecialClients
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"relo rob" wrote:
Sorry but I am confused. The "clients" are in colum P and the 20 that I am am
trying to find may or may not be in the 1500 rows in colum p. Will that still
work?