title: Conditional Formatting Fails on Rounded Numbers
body: <p>Cell <code>P10</code> has 120 but that's because row 10 is rounded to whole numbers. The actual value entered are 10.1 which is why that row sums to 121. I am trying to highlight <code>P10</code> if it doesn't match the sum of the non rounded numbers. What am I doing wrong?</p>
  
  <p><img src="https://i.stack.imgur.com/yiNhf.jpg" alt="Pic"></p>
  
  <p>The formula is:</p>
  
  <pre><code>=SUM($D$14:$O$48)&lt;&gt;!$P$10
  </code></pre>