Create or Edit Conditional Formatting Rule Dialog
The Create or Edit Conditional Formatting Rule dialog allows you to define or modify rules that apply specific formatting to rows based on property conditions.
The Create/Edit Conditional Formatting Rule dialog serves two purposes. It allows you to create new conditional formatting rules and it also allows you to edit rules that you've previously created.
In both cases, the Create/Edit Conditional Formatting Rule dialog allows you to specify the following:
Field Descriptions
| Field | Description |
|---|---|
| Format rows with | This setting identifies the property that must exhibit a specific condition in order for the formatting rule to apply. |
| Condition | This setting specifies the condition that the property must exhibit in order for the formatting rule to apply. |
| Value | This setting stores the value - or values in some cases - to which the condition is compared. |
| Background Color | Select a background color that will apply to the rows that meet the specified condition. |
| Text Color | Select a text color that will apply to the rows that meet the specified condition. |
| Background gradient | Select this checkbox to apply a gradient to the background color when the specified condition is met. This checkbox becomes active only after you select a background color. |
| Bold text | Select this checkbox to use bold text for the rows that meet the specified condition. |
