Highlighting matching values in a two column spreadsheet

T

trafficbroker

I've got a spreadsheet with two columns of data.
The first column is a list of words, for example:

one
three
two
eight
seventwo
nine
three two

The second column contains a list of all the words I want to check th
first column for, e.g:

two
nine

I want to be able to check the values of each cell in the second colum
and highlight any cells in the first column that correspond with any o
them. So in the example, 'two' 'seventwo' 'three two' and 'nine' woul
all need to be highlighted.

Any help would be greatly appreciated, thanks :
 
Top