title: Conditional Formatting Not Applying To All Cells
body: <p>I'm trying to highlight cells B3:D9 if the difference between D8 &amp; D9 is more than or equal to 10,000.</p>
  
  <p>I set up a true/false formula rule <code>=ABS($D8-$D9) &gt;=10000</code> that applies to cells <code>=$B$3:$D$9</code>. When it's true, the range of cells should be highlighted and when it's false, it should go back to normal.</p>
  
  <p>The problem is that only cells B3:D4 and cells B7:D9 are affected - B5:D6 sees no change when the formula is true.</p>
  
  <p>Another problem is that when the formula is false, the formatting doesn't go away.</p>
  
  <p>Any help would be greatly appreciated.</p>
  
  <p><a href="https://i.stack.imgur.com/pF03J.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pF03J.png" alt="enter image description here"></a></p>