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. |