Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two columns of data, one which contains a large number of values (column a), while the other contains a smaller amount of values(column e). I was wondering if anyone knew how to search for and highlight the values in column a, that are contained in column e (using column e a list of values which should be searched for) Here is what initial setup would look like: enter image description here

and here is what the result would look like: enter image description here

I've am able to search for and highlight single text values just find, I just cannot figure out how to search for a list of values all at once though. I actual list of items that I would be search for amounts to a couple hundred values, so manually search for individual strings of text would take forever. Any help is much appreciated, thanks!

share|improve this question
up vote 2 down vote accepted

If the column E values are in E1:E7 then try selecting column A and applying this formula within conditional formatting (use the "use a formula to determine which cells to format" option)


Set format or fill as required > OK

share|improve this answer
worked perfectly, thanks! – lacrosse1991 Jan 24 '13 at 16:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .