title: Excel conditional formatting graded color scale only valid inside the range
body: <p>I tried to search for a similar problem but I haven't found one.
  Basically, I want to do use this rules for the formatting:</p>
  
  <ul>
  <li><p>value from 1 to 89: graded color bar from red to orange;</p></li>
  <li><p>value from 90 to 94: yellow;</p></li>
  <li><p>value from 95 to 105: green;</p></li>
  <li><p>value from 106 to 110: yellow;</p></li>
  <li><p>value from 111 to 200: graded color bar from orange to red; </p></li>
  </ul>
  
  <p><a href="https://i.stack.imgur.com/XTlR0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XTlR0.png" alt="rules of conditional formatting"></a></p>
  
  <p>The problem is that the graded color bar rules apply also for values outside of the range that I have input.
  So for example, with the rules set up in that way as in picture, the value 200 will be in orange, because the rule before the last will apply also for value outside the range and greater that 89. </p>
  
  <p>Is there any advice to solve this?
  Thanks</p>