title: SSRS Formatting for negative numbers
body: <p>Ok, so I am familiar with formatting the colors of a cell like this</p>
  
  <pre><code>=IIF(SUM(Fields!Dollars.Value) &lt; 0, "Red", "Black")
  </code></pre>
  
  <p>but, I have inherited a report that has 80 columns and 4 rows of calculated fields which all print out black. I have been tasked with changing the format to represent negative numbers as red.</p>
  
  <p>Does anyone know of an easy was to represent "CurrentValue" in a formula instead of referencing the textbox or report field?</p>
  
  <p>Something along the lines of </p>
  
  <pre><code>=IIF(SUM(CurrentCellValue) &lt; 0, "Red", "Black")
  </code></pre>
  
  <p>This way I can select the whole table and add this formula to the font color. Otherwise I will have to change the formula on 80*4 fields. I really don't want to do that</p>