The ITabFormatValues interface contains properties of the conditional format, formatting cells on the basis of their values.
Property name | Description | |
IconCount | The IconCount property returns the number of icons, used for formatting. | |
IconType | The IconType property determines the type of icon used when formatting cells. | |
MaxValue | The MaxValue property determines the value of the condition, by which cells with maximum values will be selected. | |
MaxValueColor | The MaxValueColor property determines the final color of the gradient, used for cell formatting. | |
MaxValueType | The MaxValueType property determines the type of the condition, by which cells with maximum values will be selected. | |
MidValue | The MidValue property determines the condition, by which the minimum allowed value for cells to be formatted is set. | |
MidValueColor | The MidValueColor property sets middle color for the gradient or histogram color depending on the formatting style currently applied to cells. | |
MidValueType | The MidValueType property determines the type of the condition, by which the minimum allowed value for cells to be formatted is set. | |
MinValue | The MinValue property determines the condition, by which the minimum allowed value for cells to be formatted is set. | |
MinValueColor | The MinValueColor property determines the starting color of the gradient, used for cell formatting. | |
MinValueType | The MinValueType property determines the type of the condition, by which the minimum allowed value for cells to be formatted is set. | |
PointCondition | The PointCondition property determines the ratio, by which values, satisfying the condition, are selected. | |
PointType | The PointType property determines the type of the condition, by which a value for the specified rule is set. | |
PointValue | The PointValue property determines the condition, by which the value for cells, to which the specified rule applies, is set. | |
ReverseIcons | The ReverseIcons property determines whether the reverse order is used for icons on formatting. | |
ShowValues | The ShowValues property determines whether cell values should be displayed when conditional formatting is used. | |
Style | The Style property determines the formatting style of cells based on their values. |
See also: