Search list, locate highlight (VBA)

[mdvr]

Good day,


I have a list of key words in column A (134 of them) i.e. "Red roses, Black car, etc" and I am looking to paste a range of data (text) in column B.


What I'm looking to accomplish is the ability to locate and highlight the cell within Column B that would contain the specific words "Red roses, black car, etc" that are located in the list on column A.


In the event "car, black, Red etc" are located in B, the script would skip these.


Any quidance or assistance is greatly appreciated.

 

[kchiba]

Hi,


You do not need VBA, you could use CONDITIONAL FORMATTING.


You could put the following in the formula in the Conditional Formatting, note that A1 is not absolute


=MATCH(A1,$B$1:$B$137,0)>0

 

[kchiba]

Hi,


The above highlights the cell in Column A, but you could use the same logic to format column B.