title: Excel COUNTIF cell contains a given text (partial match)
body: <p>I have a conditional formatting with cells like</p>
  
  <pre><code>=COUNTIF(A3:H2663;R5)
  </code></pre>
  
  <p>If the value entered into <code>R5</code> is found elsewhere, the box will then turn red. </p>
  
  <p>However, sometimes it's not an exact match, and then it doesn't recognize it. That may be because of an extra figure at the end of the entered number. </p>
  
  <p>So my question is: can I change the formula to make a match, if the cells from <code>A3:H2663</code> simply contain the value in <code>R5</code>, and isn't an exact match? </p>