Yes, the title is a bit confusing but if someone has a better way of explaining it (after reading my post) please do let me know, I would gladly replace it! :-)
Anyways, here we go.
I have one list of names. These are full names. For example, a name in the list would be:
Junior John Jeremy Jackson Juvenile.
Then, I have another list of names but they are partial names but belong to the above mentioned list. For example, a name in the list would be:
Junior Juvenile.
It is to be noted that both names are actually belonging to one person but one name is short and the other full.
I want to use Junior Juvenile in order to highlight Junior John Jeremy Jackson Juvenile.
I think there would be a way do it using Conditional formatting but a formula would be also much appreciated.
I really hope I explained it well.
Thank you very much guys in advance!
Bookmarks