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