title: Using CountIf Function to highlight cell
body: <p>I have 2 lists, i want to find if the values from list 1 included in list 2.</p>
  
  <p><strong>List 1</strong>
  laci      | TRUE
  Ask? Gm?d | FALSE
  d* <em>luis  | TRUE
  luis</em> d*  | FALSE</p>
  
  <p><strong>List 2</strong>
  Apolonia Fier |
  Atletico Clube De Portugal |
  Bregalnica Stip |
  Costuleni |
  don, luis |</p>
  
  <p>I managed to do that with this formula and wildcards</p>
  
  <p><code>=COUNTIF(A5:A104,"*"&amp;F6&amp;"*")&gt;0</code></p>
  
  <p>My question now is, how can i highlight the "matched" cell in list 2 ?</p>
  
  <p>It looks so easy but i think its not.</p>
  
  <p>Thanks for your time.</p>