title: Conditional Formatting Highlighting blank Cells
body: <p>I am using conditional formatting to highlight some cells which do not lie between the input range.While this I am getting blank cells highlighted as well.
  Formula I used is </p>
  
  <pre><code>OR(B2&lt;$R2,B2&gt;$S2)
  </code></pre>
  
  <p>Here value of B2 is say -1
  Value of R2 is -1 and S2 is also -1
  The Row 1 just contains -1 in one cell(B2)
  Except for that cell every other cell gets highlighted.
  I am not getting the reason for blank cells getting highlighted</p>
  
  <pre><code>For illustration
      A  B  C .............P Q R  S
   1    -1                    -1 -1
   2
   3
   .
   .
  </code></pre>
  
  <p>So basically highlight the cells which have value outside the range(-1,-1) 
  But this highlights all blank cells of the row 1 which ideally shoudnt because they dont have any value in them</p>