Adding another highlight function to my code that matches lists

[danielhliu]

Hi,

I have this code here that basically will search through a data list "A" by searching for each data element in list "L". If there is a match, then the element will be highlighted in A. Is there a way to highlight every element in data list L that is found in A? In other words, I would like the end product to have all found elements to be highlighted on both data list A and L. All items that havent been found would be unhighlighted. Any help would be awesome- thanks.

Please Login or Register  to view this content.

[StephenR]

Try declaring SrchValue as a Range, adding Set to the line below

Please Login or Register  to view this content.

and adding the second line below

Please Login or Register  to view this content.

Does that do what you want?

[Kenneth Hobson]

Have you considered using 2 dynamic ranges and data validation? If the =CountIf is >=1 then a match was found.

[danielhliu]

Thank you guys, adding those two lines of code did the trick