Hi!

I've checked a few threads on this matter, but they don't quite cover what
I'm after.
I have an Excel document with several columns full of words and numbers.

I have a Master column, which contains the Initial List. (A)

I want to compare all the remaining columns to A, but not to each other.

So that for example;

B,C,D,E,F,G all compare against A and highlight within themselves, any words
that match anything in A.
The Slave columns will continue to grow, so the Formula would be something
that can be copied and pasted to new Columns with minimal change. Preferably
something that checks the entire column, with no number limit, as the columns
are of varying length.

Any help would be really, really appreciated, and I hope I've explained
myself well enough!

Thanks!!