title: Conditional Formating not showing correct results
body: <p>I am having a problem while applying conditional formatting in MS Excel 2016.</p>
  
  <p>I have two numeric columns <code>[P &amp; Q]</code>. And want to highlight cells in column <code>P</code> where the value is greater than its corresponding cell in column <code>Q</code>. I have used the following formula. </p>
  
  <pre><code>=$P1 &gt; $Q1
  </code></pre>
  
  <p>In conditional formatting. The formula would be applied on some 1500 rows in column <code>P</code>. However I am getting wrong results as well as correct ones. I have attached an image of some results. Need help.</p>
  
  <p><a href="https://i.stack.imgur.com/HEjE9.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HEjE9.jpg" alt="enter image description here"></a></p>