SSRS: Conditional Formatting for Negative Numbers

If you have an SSRS report and want to apply some conditional formatting to negative values, follow these steps:

  1. Select the value in the Tablix to which you would like to apply conditional formatting.
  2. In the Properties pane, go to the 'Font' group and go to 'Color'. Click the drop-down and choose the last option, 'Expression...'.
  3. The Expression window will open. In the text box at the top enter the following: =Iif(Fields!NameOfYourField.Value<0,"Red","Black")
  4. Click 'OK'.
Of course you can modify this to use any other logic and colours. This simple example will display negative values in red and everything else in black.


Post a Comment