Setting Conditional Formatting for Report Item

To set conditional formatting for report items:

1. Create and open a report definition file in Microsoft Excel. (For the purposes of this article, we’ll use the test case (Company Sales 2008.rdl).
2. Select the Sale List worksheet.

1. Select cell I6 and add conditional formatting to this cell for the table report item.
   1. Format cells that are less than 1000 with light red fill with dark red text.
   2. Format cells that are greater than 1000 with light yellow fill with dark yellow text.
2. Set more conditional formatting for one cell.

1. Save, publish and review the report.

1. Add conditional formatting for this cell for matrix report item or textbox report item.

1. Save, publish and review the report.