title: Excel Conditional Formatting - Containing Multiple Matches
body: <p>Trying to avoid VBA and use one Conditional Formatting rule.</p>
  
  <p>I want to apply a format to cells that contain one or more possible phrases.</p>
  
  <pre><code>   |   A    |
  ---+--------+---
   1 | foo    |
   2 | bar    |
   3 | foobar |
   4 | baz    |
   5 | foobaz |
   6 | qux    |
   7 | barqux |
  </code></pre>
  
  <p>Goal: apply conditional format to 'foo' and 'baz' (rows 1,3,4,5)</p>
  
  <p>Something like the following should work, however I think the problem is in identifying the current cell to compare, in this case the <code>A1:A7</code> needs to be the current cell reference:</p>
  
  <pre><code>=OR( IFERROR(FIND("foo",A1:A7),0) &gt; 0, IFERROR(FIND("baz",A1:A7),0) &gt; 0 )
  </code></pre>
  
  <p>Any ideas?</p>