title: SRSS Conditional formatting colour with value ranges?
body: <p>I have a sql reporting services report that displays sales from all of our stores etc it includes a column which displays a % to budget value. What I want to do is if the value is <code>&gt;= .35</code> then make it the background of the cell <code>Green</code>, if the value is <code>&lt; .35 and &gt; .30</code> then <code>Yellow</code> if the value is <code>&lt; .30 then Red</code>.</p>
  
  <p>It's really doing my head in I just can't seem to get it to work with all 3 ranges.</p>
  
  <p>I can put in the background color properties of the cell the expression:</p>
  
  <pre><code>=IIF(Fields!ID__to_Budget.Value &gt;= 0.35, "Green", "Red")
  </code></pre>
  
  <p>And that works, but of course I don't have any Yellow range, anything under .35 becomes red.</p>
  
  <p>I have been trying to do a nested expression on the background color like this: </p>
  
  <pre><code>=iif( (Fields!ID__to_Budget.Value &gt;= 0.35), "Green",
        ( iif(Fields!ID__to_Budget.Value &lt;0.35 and &gt; 0.30, "Yellow",
           iif(Fields!ID__to_Budget.Value &lt; 0.30 "Red", "White") ) ) )
  </code></pre>
  
  <p>but it complains about a syntax error on the "and >0.30" part.</p>
  
  <p>Many thanks
  Lance</p>