Hi,

Let's say the names are in A3:A50. The names which you want to colour are
in B5:B500. While on cell B3, go to Home Styles Conditional formatting
New Rule Use a formula to determine which cells to format and in the
box, there, type the following formula

B3=vlookup(B3,A$3:A$50,1,0). Select the desired format and click on OK

To copy and paste conditional formatting, copy cell A3, Edit Paste Special
Formats

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Wendy" wrote in message
...
I want to be able to colour code the name of jo bloggs when his name
apprears
in a cell that has many names. I have been able to colour code a range of
cells with a few names but I have a list to 200 names that I need to check
against the same listing of names.

I used conditional format but need to be able to apply this to a large of
names against a set of data that holds many names.


Wendy