title: Google Sheets Match Any Text
body: <p>In Google Sheets, I have 2 columns (A and B) of text and I'm trying to set up conditional formatting to identify partial duplicates for when these 2 criteria are both met:</p>
  <ul>
  <li>Text in A exactly matches with any other cell in A</li>
  </ul>
  <p>and</p>
  <ul>
  <li>Any of the individual words in cell B match any of the words in any other cell in B</li>
  </ul>
  <p>So, if A2 = &quot;target.com&quot; and B2 = &quot;Big Bonus&quot;</p>
  <p>I want it to flag any other cells where A = &quot;target.com&quot; and B = &quot;Bonus Donuts&quot; or &quot;Biggest Exciting Bonus Ever&quot; (because &quot;Bonus&quot; is identified as the duplicate) or &quot;Exciting Big Day&quot; (because &quot;Big&quot; is identified as the duplicate).  I need it to be case-agnostic.</p>
  <p>Nothing I have tried has even come close to working, so I won't include any of it here.</p>
  <p>Sample Data: <a href="https://docs.google.com/spreadsheets/d/1DO-0uJRf6MOJ7fJiza5MAmFNIqpCwJ4WMH28j6wp22w/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1DO-0uJRf6MOJ7fJiza5MAmFNIqpCwJ4WMH28j6wp22w/edit#gid=0</a></p>