title: Change background color of a cell if not between two values and not blank
body: <p>I am trying to change the color of a cell's background to red if the cell's value is not between 0.0086 and 0.0094, and also not blank. I have successfully covered the part less than 0.0086, but the other two conditions keep giving me errors. Below is my code thus far</p>
  
  <pre><code>=(($D$2:$D$1000) &lt; 0.0086) AND (($D$2:$D$1000) &gt;  0.0096) AND NOT(ISBLANK(($D$2:$D$1000)))
  </code></pre>