title: How to compile conditional 3 color-scale Excel rule
body: <p>I want to know what I would need to type into the formula box in excel to solve the problem outline below:</p>
  
  <p>Key: <code>*Variable/Cell*</code></p>
  
  <pre><code>IF *cellnumber* = 0 shade cells red
  IF *cellnumber* &gt; (more than) 0 but &lt; (less than) *cell number* shade cells yellow
  IF *cellnumber = *cellnumber* shade cells green.
  </code></pre>