The ITabFormatCondition interface contains properties of cell conditional format.
Property name | Brief description | |
AppliedRange | The AppliedRange property determines a range of cells for which conditional formatting is applied. | |
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. | |
Type | The Type property determines the type of the conditional format, applied to cells. |
Method name | Brief 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: