title: Searching & Highlighting Multiple Values
body: <p>I have two workbooks open, one with a master list of 4280 survey ID #s &amp; one with a select group of about 420 survey ID #s (called "DNAs").</p>
  
  <p>The master list includes all of the DNA survey IDs. I would like to search for the DNA survey IDs in the master list to highlight them and add this DNA code. Is there a way to do this all at once instead of individually?</p>
  
  <p>When I used different formulas given in other answers, I did not get what I needed. Here is a similar situation to mine:</p>
  
  <p><a href="https://stackoverflow.com/questions/14939352/how-to-search-for-multiple-values-in-one-excel-sheet-and-copy-it-to-another-shee/24495855#24495855">how to search for multiple values in one excel sheet and copy it to another sheet</a></p>