Adding Conditional Formatting
You can design a report so that different styles are applied to items based on the data in the report. For example, negative numbers in a report can be displayed in red.
To make styles dynamic, use an expression instead of a static value for the style properties of the item. For example, to make a text box return a negative value in red for the field Profit, use the following expression in the Color property of the text box:
=iif(Fields!Profit.Value < 0, "Red", "Black")
Creating a Green-Bar Report
To apply a green-bar effect (alternating colors every other row) to a table in a report, use the following expression in the BackgroundColor property of each text box in the detail row:
=iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White")
You can build expressions based on a number of functions. For more information, see Using Expressions.