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.