Spread Windows Forms 9.0 Product Documentation
Manage Rules

The Conditional Formatting Rules Manager dialog allows you to add, edit, or delete conditional formatting rules.

The Show formatting rules for option allows you to choose Current Selection or This WorkSheet. You can use the up and down arrows to move up and down the rule list.

Button Description
New Rule Click the New Rule button to display the dialog for adding new rules.
Edit Rule Click the Edit Rule button to edit an existing rule.
Delete Rule Click the Delete Rule button to delete the currently selected rule.
OK Click this button to accept the changes.
Close Click this button to close the dialog.
Apply Click this button to apply the changes.
Column Description
Rule The Rule column displays the type of rule.
Format The format displays the format applied to the cell.
Applies to The Applies to column displays the cell or cell range that the rule applies to.
Stop If True The Stop If True column determines whether to ignore any rules applied to the cell after this rule. The rules are always processed in the specific order shown in the Conditional Formatting Rules Manager dialog for the cell or range.

The following image displays the dialog for adding new rules.

This image displays multiple rules that have been created with the rules manager.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback