title: Google Sheets - Highlight cell if value exists in other sheet
body: <p>I would like to highlight a cell if a value matches a cell in another sheet.</p>
  <p><strong>Proposed Solution</strong></p>
  <pre><code>FOR EACH row in 'sheet1'
  
  IF column C == TRUE 
  &amp;&amp; column D (value split by comma, only search values with 'tf' in) does not match any cell in 'sheet2'
  
  Highlight the cell Red
  </code></pre>
  <p><strong>Example Value</strong></p>
  <blockquote>
  <p>CELL D9</p>
  <p>&quot;Platform,TF Platform,TF User&quot;</p>
  </blockquote>
  <ol>
  <li>Do not search &quot;Platform&quot; in sheet2</li>
  <li>Search &quot;TF Platform&quot; in sheet2</li>
  <li>Search &quot;TF User&quot; in sheet2</li>
  </ol>
  <p><strong>Example Sheet</strong></p>
  <p><a href="https://docs.google.com/spreadsheets/d/1eI9FTVNuyMEzQTJnHzufz_gElE53AMmk-mxVEWKPdRk/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1eI9FTVNuyMEzQTJnHzufz_gElE53AMmk-mxVEWKPdRk/edit?usp=sharing</a></p>