title: Excel: apply conditional formatting if cell contains one of x strings
body: <p>What I'm trying to do should be quite simple but I am getting error messages saying that conditional formatting doesn't accept this method.</p>
  
  <p>So I am looking for a fix or an alternative.</p>
  
  <p>What I have is a list of search texts for phone faults</p>
  
  <p>screen broken
  wifi not working
  bluetooth dead
  the dooflip isnt working
  etc.</p>
  
  <p>I have also set up a number of common keywords</p>
  
  <p>screen
  wifi
  bluetooth</p>
  
  <p>By comparing these two we can see that the last one doesn't adhere to any of my common keywords, and so I want it highlighted/ copied somewhere etc. so I can view and take any action.</p>
  
  <p>So far I have attempted to set up conditional formatting to search the terms for the keywords and if it doesn't contain any then highlight it.</p>
  
  <pre><code>=ISERROR(SEARCH({"wifi", "bluetooth", "screen"},$H$117))
  </code></pre>
  
  <p>When using this I get informed that conditional formatting does not support arrays (it works fine if I only specify one search term).</p>
  
  <p>If i create a table with all the keywords in and use the following it works, however it will only find direct mataches, and wont search for the word in the cell string</p>
  
  <pre><code>=ISERROR(MATCH(&lt;cell_to_change_colour_of&gt;, &lt;keyword_table&gt;,0))
  </code></pre>
  
  <p>So is there another way of doing this?</p>