title: Google Sheets Highlighting using Conditional Formatting for Text that DOESN'T Contain "x" - TWO Criteria
body: <p>I plan to use Google Sheet's conditional formatting to highlight cells where the text DOES NOT contain:</p>
  
  <ul>
  <li>Retail</li>
  <li>FinServ</li>
  <li>Manufacturing</li>
  <li>Field Service</li>
  <li>Managed Services</li>
  <li>Digital Transformation</li>
  <li>Ecommerce</li>
  <li>Data and Analytics</li>
  </ul>
  
  <p>For the above phrases, I want to be able to add additional details, separated by an underscore (_), and have the row still NOT be highlighted. For ex: Retail_Blog should still NOT be highlighted because it begins with one of the phrases above. </p>
  
  <p>To do this, I'm currently using the formula:  </p>
  
  <p><code>=regexmatch(F:F,"Retail|FinServ|Manufacturing|Field Service|Managed Services|Digital Transformation|Ecommerce|Data and Analytics")=FALSE</code></p>
  
  <p>This formula works great for the specifications above, but I also would like the formula to do adhere to another rule. </p>
  
  <p>For the phrases below, I would like the formula to highlight cells if they DON'T EXACTLY match the phrases. For ex: "Meetings" should NOT be highlighted, but "meetings," "Meeting," and "Meetings_whatever" SHOULD be highlighted.</p>
  
  <ul>
  <li>Meetings</li>
  <li>Website Updates</li>
  <li>Press Release and Distribution</li>
  <li>Calendar Planning</li>
  </ul>
  
  <p>Also, this formula would be for the range F:F.</p>