title: Excel: highlight cell if exists in list
body: <p>I want to create a conditional formatting rule where the cell will be highlighted if it also appears in a list (column A).</p>
  
  <p>The values are all text (e.g "Apple", "Pear"). It has to be an exact match ("Apple Juice" shouldn't be highlighted if "Apple" is in the list). The result should be this: <a href="https://i.stack.imgur.com/CZj7z.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CZj7z.png" alt="Image of spreadsheet"></a></p>
  
  <p>Help will be greatly appreciated!</p>