Understanding the Edit Rule Dialog Box
The Edit Rule dialog box allows you to configure a conditional formatting rule. Configuring a conditional formatting rule is a 3-step process:
1. Enter a name in the Name field.
2. On the Conditions tab, define the conditions (filters).
3. On the Formatting tab, specify the formatting to apply when the condition(s) are met.
Each of the fields and buttons in the Edit Rule Dialog is described below:
Using the Conditions Tab
The
Conditions tab allows you to define the filter criteria to be met for the formatting rule to be applied. See
“Creating and Editing Filters Using the Edit Filter Dialog Box” for more information on filters.
Using the Formatting Tab
The Formatting tab allows you to specify the type of formatting to be displayed if the conditions are met.
Fields and Buttons
• Format Full Row: Specifies whether this rule will apply to the whole row of the table when font or color conditional formatting modes are set to Row.
• Format Columns: Allows you to select the column(s) to apply the formatting to.
Note: If no columns are chosen, then the formatting will apply to the first column of the table when the conditional formatting modes are set to Cells.
• Check Boxes: The check boxes to the left of the following fields control whether a particular field is enabled for the rule. These are automatically enabled when a field is set, but can also be enabled manually. For example, if you wanted a rule to override an earlier rule you could revert the colors or font settings to defaults by checking the box, but leaving the field at its default setting.
• Color: Allows you to select the Foreground (font) and Background (cell/row) colors.
• Cells Mode (Color): is enabled when Format Full Row check box is selected. Allows you to specify which columns the formatting rule will be applied to when the User has set Table Color Formatting mode to Cells:
• Disabled in cells mode: formatting will not be seen by Users who have Table Color Formatting Mode set to Cells or None.
• Apply to format columns only: Formatting will be applied to all columns you specified in the Format Columns field. Users will see this formatting when they have Table Color Formatting Mode set to "Cells" or "Row".
• Apply to Locked columns only: formatting will be applied to all locked columns.
• Apply to full row always: Formatting will be applied across the whole row, even if the User has Table Color Formatting mode set to Cells.
• Font: Allows you to select the font.
• Cells Mode (Font): Enabled when Format Full Row check box is selected. Allows you to specify which columns the formatting rule will be applied to when Table Font Formatting mode is set to Cells:
• Disabled in cells mode: Formatting will not be seen by users who have Table Font Formatting Mode set to Cells or None.
• Apply to format columns only: Formatting will be applied to all columns you specified in the Format Columns field. Users will see this formatting when they have Table Font Formatting Mode set to Cells or None.
• Apply to locked columns only: Formatting will be applied to all locked columns.
• Apply to full row always: Formatting will be applied across the whole row, even if the Table Font Formatting mode has been set to Cells.
• Bold: Enables to apply bold font formatting.
• Italic: Enables you to apply italic font formatting.
• Underline: Enables you to apply underline font formatting.
• Strikethrough: Enables you to apply strikethrough font formatting.
• Cell Tooltip: Enables you to enter a descriptive tooltip for the rule. The tooltip is displayed when a user holds the mouse pointer over any cells highlighted with the formatting.
• Preview: The Preview pane shows what the formatting rule will look like for users under different formatting modes: None, Cells, or Row. Conditional formatting modes are set by each user from the Web Workspace User menu's Table Settings sub-menu. The preview table shows two example locked columns and two example not locked columns.