Specific Names

  • Thread starter Thread starter yoly
  • Start date Start date
Y

yoly

I have a column of comments about certain Names in individual rows. I also
have a column with a list of just names. all of the names in column A are
random. the names in column b are in alpha order. I would like to create
either a conditional format or a formula to identify the names in a row..
without reading each row to locate the names.

Ex
a1 I love talking to jennifer but i also like working with Heidi.
a2 Justin answered all our questions before we had to ask.

b1 Michael
b2 Joan
b3 Jennifer
b4 Justin

Please help.
 
Maybe i should clarify that column A contains comments - some with names and
some without.. so there are a lot of random words.. and I am only interested
in the cells that refer to someone's name. I am really trying to avoid
reading every cell.

Thanks.
 
Back
Top