title: Format all values in a dynamic value range
body: <p>I have a start value of <code>500</code> in I20. This represents a monthly installment. This installment increases every 12 months at a fixed rate, which is placed in C9 (e.g. <code>3%</code>). These installments are written into Column I. To calculate this, I have a helper column E which starts with <code>0</code> and is incremented by <code>1</code> every twelve rows. Also in column I are values which are calculated differently.</p>
  
  <p>I want all values in column I which fall into this specific value range [(=<code>500 * (1+C9)^E20</code>) = (e.g. <code>500</code>, <code>530,45</code>, <code>546,36</code> etc.)] to be formatted in a special way.</p>
  
  <p>What does the formula for the conditional formatting in I20 have to look like so that I can apply it to the entire column? </p>
  
  <p><a href="https://i.stack.imgur.com/xDJXq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xDJXq.png" alt="enter image description here"></a></p>