title: Search Value and highlight Row
body: <p>I am using conditional formatting to search a value in a cell and apply it to a specific column. If the data matches it highlights the entire row. The issue I am having is that if I search the value of &quot;20&quot; and that number is a part of a value in the search range such as &quot;120&quot; it highlights the &quot;120&quot; row also. Is there a way to only highlight the rows that contain values of &quot;20&quot; and not highlight partial matches?</p>
  <p>Here is the formula I am using.</p>
  <pre><code>=SEARCH($C$6,$C10)
  </code></pre>
  <p>Best,</p>
  <p>D</p>