The ITabFormatCondition interface contains properties of cell conditional format.
Property name | Description | |
AppliedRange | The AppliedRange property determines a range of cells for which conditional formatting is applied. | |
Condition | Outdated.The Condition property sets condition to be tested for each cell. | |
DataAdapter | The DataAdapter property determines data source for cell conditional format. | |
Details | The Details property determines specific settings of the defined conditional format. | |
Enabled | The Enabled property determines, whether the current conditional format is used. | |
Key | The Key property returns the key for a conditional format. | |
Range | The Range property determines the table cell range, for which conditional format should be set. | |
Style | Outdated.The Style property determines the style to be applied to the cell if the condition is satisfied. | |
Type | The Type property determines the type of the conditional format, applied to cells. |
Method name | Description | |
AssignPredefinedDataBar | The AssignPredefinedDataBar method loads settings of the standard conditional format with a histogram to the current conditional format. | |
AssignPredefinedGradient | The AssignPredefinedGradient method loads settings of the standard conditional format with gradient fill to the current conditional format. | |
AssignPredefinedGrowth | The AssignPredefinedGradient method loads growth indicator settings to current format. | |
AssignPredefinedIcons | The AssignPredefinedIcons method loads settings of the standard conditional format with icons to the current conditional format. | |
AssignPredefinedScale | The AssignPredefinedScale method loads parameters of standard color scale to the conditional format. |
See also: