| Name | Description | |
|---|---|---|
 | Item | Overloaded. Gets the rule at the specified index. |
| RuleCount | Gets the number of rule objects in the collection. |
ConditionalFormat Class Members
In This Topic
The following tables list the members exposed by ConditionalFormat.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | AddAverageRule | Adds an average rule to the rule collection. |
| AddCellValueRule | Adds the cell value rule to the rule collection. |
| AddDataBarRule | Adds a data bar rule to the rule collection. |
| AddDateOccurringRule | Adds the data occurring rule to the rule collection. |
| AddDuplicateRule | Adds a duplicate rule to the rule collection. |
| AddFormulaRule | Adds the formula rule to the rule collection. |
| AddIconSetRule | Adds an icon set rule to the rule collection. |
| AddRule | Adds the rule. |
| AddSpecificTextRule | Adds the text rule to the rule collection. |
| AddThreeScaleRule | Adds the three scale rule to the rule collection. |
| AddTop10Rule | Adds the top 10 rule or bottom 10 rule to the collection based on the Top10CondtionType. |
| AddTwoScaleRule | Adds the two color scale rule to the rule collection. |
| AddUniqueRule | Adds a unique rule to the rule collection. |
| ClearRule | Removes all rules. |
| ContainsRule | Determines whether the specified cell contains a specified rule. |
| GetRules | Gets the conditional rules from the cell at the specified row and column. |
| RemoveRule | Overloaded. Removes the rules for a specified cell. |
| ToArray | Copies the rules to a new array. |
See Also