casey,

1. Select the cells in Column A that you want to have this conditional
formatting.
2. Click Format Conditional Formatting...
3. Change "Cell Value Is" to "Formula Is"
4. Enter the following formula (using your example posted: Range B1:B4):
=not(isna(vlookup(A1,$B$1:$B$4,1,0)))
(that formula assumes that in your selection (A1:A4), cell A1 is the active
cell)
5. Set your formatting accordingly.

HTH,

Conan




"casey" wrote in message
...
How do I conditionally format a cell if the data in the cell matches any
cell
in a list of 100?

For example:

Col A Col B
bob art
jim bob
kirk will
greg sam

I want to format the cells in Col A such that "bob" will fill red with
white
letters if his name shows up in Col B