title: Conditional Formatting exact text match
body: <p>I have several spreadsheets where I want to highlight all the rows where the data matches a separate list. I have used a rule for this but it's not highlighting it exactly; it's just matching part of the word, for example <code>General manager</code> in one list is highlighting <code>Manager</code> in the other list whereas I would only want it to highlight <code>General manager</code>.</p>
  
  <p>This is the formula I've used:</p>
  
  <pre><code>=COUNTIF(A92:A400,L2:L196)  
  </code></pre>
  
  <p>and I've also tried MATCH but it pulled out out even more incorrect matches.</p>