title: How to format background color of a cell which is under a group? - SSRS 2008 R2
body: <p>I have the following matrix:</p>
  
  <ul>
  <li>Design view</li>
  </ul>
  
  <pre class="lang-none prettyprint-override"><code>--------------------------
  |  OfficeSID  | [Type]   |
  --------------------------
  | [OfficeSid] | [Value]  |
  --------------------------
  </code></pre>
  
  <ul>
  <li>Preview</li>
  </ul>
  
  <pre class="lang-none prettyprint-override"><code>----------------------------
  | OfficeSID |   A  |   B   |
  ----------------------------
  |    1      | 1029 |  982  |
  ----------------------------
  |    2      |   98 |  782  |
  ----------------------------
  |    3      |  786 |   82  |
  ----------------------------
  |    4      |   29 |    2  |
  ----------------------------
  </code></pre>
  
  <p>I want to format background color of the cells i.e 2nd row, 2nd column which is a value field. It is grouped under Type field. 
  The background color should be the following:</p>
  
  <ul>
  <li>If value &lt; 0 red  </li>
  <li>If value &lt; 100 and > 0 Orange</li>
  <li>If value >= 100 Green</li>
  </ul>
  
  <p>I tried using expressions but it dint work.</p>