OrgPlus 6 - Conditional Formatting
OP-0600-S1114
Summary:
Conditional formatting allows you to dynamically apply formatting to a sub-set
of a chart that meets a set of user-defined criteria.
Procedure:
To create a conditional format:
Select Conditional Formatting from the Format menu.
The Conditional Formatting dialog box is displayed.
Click Add. The Conditional Formatting dialog box Define
Condition tab is displayed.
Enter the condition name in the Condition Name field.
Define the criteria for the condition as follows:
- Define the first search criteria expression by selecting from the Field Name and Comparison drop-down lists. Then enter the comparison string in the Contents field.
- Define any additional search criteria in the second and subsequent lines by selecting the And/OR search condition for each line.
- Select Match Case to match only words that are capitalized the same way as the text in the Contents field.
- Select Whole Word Only to match only complete words that match the Contents field entries.
Click OK. The Conditional Formatting Rule is added to the list of rules in
the Conditional Formatting dialog box.
Select the condition and use the Format Box and Format Fields buttons to define
a format. Click Clear Format to reset the formatting.
Click OK. The format is applied to all boxes in all charts that meet the
condition.
Note: You can disable a condition by clearing that condition's check box.
To reorder a conditional format:
Each condition is applied to the chart starting with the first condition and
ending with last condition. Any box in your chart may satisfy two or more
conditions. In this case you may need to reorder conditions to achieve the
desired formatting.
Select Conditional Formatting from the Format menu. The
Conditional Formatting dialog box is displayed.
Select a condition.
Click the up arrow
to move the condition up.
Click the down arrow
to move the condition down.
Click OK to close the Conditional Formatting dialog box.