Specific Names

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.
 
Y

yoly

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top