title: Highlight cells in a column depending on a letter present in cell range
body: <p>I have a column indicating progress on projects (in percentages) which should turn red if in the corresponding rows there is no letter <code>P</code>. With the following formula something very strange happens:  </p>
  
  <pre><code>=ISERROR(FIND("p",$H5:$Y65))
  </code></pre>
  
  <p>So I have set <code>P</code> not being an error and the cell that doesn't contain <code>P</code> should be formatted red. However, with this formula, only if there is a <code>P</code> in the first column i.e. H does it format. The formula seems to ignore all the other columns after H. </p>
  
  <p>Any suggestions?</p>