| Name | Description | |
|---|---|---|
 | getFormatColor | Returns a FormatColor object, which specifies the color assigned to the threshold of a color scale conditional format. |
| getIndex | Returns an Integer value that indicates which threshold the criteria represents. |
| getType | Returns one of the constants of the ConditionValueTypes enumeration, which specifies how the threshold values for a data bar or color scale conditional format are determined. |
| getValue | Returns the minimum, midpoint, or maximum threshold value for a color scale conditional format.
You can set the value only if the ColorScaleCriterion.Type property for the conditional format is set to one of the following constants: ConditionValueNumber, ConditionValuePercent, ConditionValuePercentile, or ConditionValueFormula. If the type of threshold is a formula, you can set the formula as a String. The formula must return a single number. |
| setType | Sets one of the constants of the ConditionValueTypes enumeration, which specifies how the threshold values for a data bar or color scale conditional format are determined. |
| setValue | Sets the minimum, midpoint, or maximum threshold value for a color scale conditional format.
You can set the value only if the ColorScaleCriterion.Type property for the conditional format is set to one of the following constants: ConditionValueNumber, ConditionValuePercent, ConditionValuePercentile, or ConditionValueFormula. If the type of threshold is a formula, you can set the formula as a String. The formula must return a single number. |