You can specify as many as seven formats when applying conditional formatting. For each format, you can create as many as seven conditions.
Additional formats are added to enable the application of multiple formats when different conditions are met. After a condition, or conditions, is formatted, you can add another format that is tied to the cell.
For example, you can create one format that contains row and column numerical conditions to be applied to the selected cell. Then, you can create another format that specifies text color, shading, or alignment for the selected cell.
To add a format:
Create a grid in a report in the Report Designer, or open an existing report containing a grid.
Select Format, and then Conditional Format to access the Conditional Format dialog box.
Add a condition to the cell, as described in Applying Conditional Formatting on Grids.
Click the Add Format #, where # is the number of the next format to be added.
To add more conditions and formats, repeat step 4 through step 6 as needed.