var instance = new GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats(worksheet);
function ConditionalFormats;
Represents a format condition class.
Syntax
Inheritance Hierarchy
Object
GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats
Constructors
| Name | Description | |
|---|---|---|
 | ConditionalFormats Constructor | Represents a format condition class. |
Methods
| Name | Description | |
|---|---|---|
 | add2ScaleRule | Adds the two scale rule to the rule collection. |
| add3ScaleRule | Adds the three scale rule to the rule collection. |
| 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 date 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. |
| addTop10Rule | Adds the top 10 rule or bottom 10 rule to the collection based on the Top10CondtionType object. |
| addUniqueRule | Adds a unique rule to the rule collection. |
| clearRule | Removes all rules. |
| containsRule | Determines whether the specified cell contains a specified rule. |
| count | Gets the number of rule objects in the collection. |
| getRule | Gets the rule using the index. |
| getRules | Gets the conditional rules from the cell at the specified row and column. |
| removeRule | Removes a rule object from the ConditionalFormats object. |
| removeRuleByRange | Removes the rules from a specified cell range. |
See Also