You can apply conditional formatting when working with grids in the Report Designer. First, you establish a condition for the selected cells. Then you specify formatting for values that meet that condition.
You can specify conditionally formatting for related content on any grid object cell. For example, if the Market member name is “East” link to “ReportA”, if the Market member is “West”, link to “ReportB”. On the Format Cells dialog, you can specify the related content links. See Replacing Text.
To apply conditional formatting:
Create a grid in a report, or open an existing report containing a grid.
Select the cells to which you want to apply conditional formatting.
Select Format, and then Conditional Format to access the Conditional Format dialog box.
From the Select Property drop-down list box, select a property.
The following table lists each conditional formatting property with the applicable data sources.
From the Reference Value drop-down list box, select a value corresponding to the property value you selected from the Select Property drop-down list box.
To add another condition, click the Add Format 2 button. Repeat step 4 through step 7 to continue adding conditions.
Select And to combine this condition with the next condition, or select Or to distinguish this condition from the next condition.
Click Format Cells to assign a format to the condition. For more information, see Formatting Grids.
Use the Allow Not and Allow Parentheses check boxes, located in the Options section of the Conditional Format dialog box, to establish logic for conditions:
When you finish adding conditions for Format 1, perform an action:
To add another format to your selection, click Add Format 2. For more information, see Adding Conditional Formats.
