Changing the Order of Conditional Formats

After you add multiple formats, you can change the order in which the conditions are evaluated and formats are applied to the selected cells. For example, suppose you specified a blue format for cells with a value of zero. In the second format, you specified a column value equal to the cell value and a row value equal to a specific number. Then, you specified a third format for the selected cell.

Using the arrows in the upper right corner of Conditional Format dialog box, you can change the order in which the formats are applied to a selected cell. The order of the formats is significant, because formats are absolute. The conditions created in the first format take precedence over the other formats and conditions.

To change the order of the conditional formats:

Create a grid in a report in the Report Designer or open an existing report containing a grid.
Select the cells whose format order you want to modify.
Select Format, and then Conditional Format.
Add three formats, as described in Adding Conditional Formats.
Select the format tab whose order you want to change.
Do either of the following:
- To move a formatted tab to the left, click the Move Left button, .
- To move a formatted tab to the right, click the Move Format Tab Right button, .
Click OK to return to the grid.