title: String "N/A" is being recognized as zero in conditional formatting formula
body: <p>I currently have an excel spreadsheet that is using the following conditional formatting formula.</p>
  
  <pre><code>=OR($M$11&lt;-5,$M$11&lt;$C$7,$M$11&lt;$H$7)
  </code></pre>
  
  <p>If the above statement is true, the cell turns green. The problem I am having is sometimes the cell H7 has "N/A" as a string (not the error #N/A) and treats the cell as zero. I am trying to re-write the conditional formatting formula so that if H7 is "N/A," the formula ignores the last inequality. Essentially, the formula would be stopping at the M11&lt; C7 part. </p>
  
  <p>Would anyone know how to adjust this formula to fix the problem I mentioned above? Thanks in advance!</p>