To make the contents of a text box render negative values in red for a field called Profit, open the Properties pane and use the following expression in the Color property:
=IIF(Fields!Profit.Value < 0, “Red”, “Black”)
To alternate the background color for every other row in a table, you can set the BackgroundColor property for each text box in the row to the same conditional expression. This technique works for detail rows only in a table with no groups.
=IIF(RowNumber(Nothing) MOD 2, “PaleGreen”, “White”)