Static
$tStatic
nextReturns the
This property is only applicable when the [[valueType]] property is set to Formula.
To assign a
[[setFormula]]
Returns the numeric value for this instance.
This property is read-only; to assign a value type, use the [[setValue]] or [[setValue]] methods.
Note that the unit of measure for this value is determined by the [[valueType]] property; for example, when ValueType is set to Number, the value is interpreted as a numeric value, but when set to Percentage, it is interpreted as a percentage.
Returns a [[FormatConditionValueType]] value which specifies the manner in which the threshold values for this instance are determined.
This property is read-only; to assign one of the following value types, use the [[setValue]] method:
To assign a value type of Number, Percentage, or Percentileuse the [[setValue]] method.
To assign a [[formula]], use the [[setFormula]] method.
[[setValue]]
Assigns the specified formula to the [[formula]] property, and assigns a value of Formula to the [[valueType]] property.
The string representation of the [[formula]] to be assigned to the [[value]] property.
A [[CellReferenceMode]] value which specifies whether the 'formula' parameter should be interpreted as an A1 or R1C1 expression. This parameter is optional and defaults to null, in which case the [[Workbook.cellReferenceMode]] property is used.
A [[FormatConditionValueType]] value which specifies the manner in which the value returned from the formula is interpreted. This parameter is optional and defaults to 'Formula'.
Sets the [[valueType]] property to the specified [[FormatConditionValueType]] value.
The 'valueType' parameter must be set to one of the following values or an exception is thrown:
To set the [[value]] property to a numeric value, use the [[setValue]] method.
To set the [[valueType]] property to Formula, use the [[setFormula]] method.
The new value for the [[valueType]] property.
Sets the [[value]] and [[valueType]] properties to the specified values.
To set the [[valueType]] property to Formula, use the [[setFormula]] method.
To set the [[valueType]] property to a [[FormatConditionValueType]] value for which the [[value]] is not applicable, use the [[setValue]] method.
[[ArgumentException]] If the value type or value is not appropriate for the condition.
[[ArgumentOutOfRangeException]] If the value is out of range.
The new value for the [[value]] property.
The new value for the [[valueType]] property. Must be set to either Number, Percentage, or Percentile or an exception is thrown.
Static
compareStatic
compareStatic
equalsStatic
equalsStatic
getStatic
getStatic
getStatic
reference
Exposes properties which define the value and its unit of measure for a conditional format threshold.
When the [[valueType]] property is set to Number, Percentage, or Percentile, only the [[value]] property is applicable.
Similarly, the [[formula]] property is only applicable whenValueType is set to Formula.
For the following settings of ValueType, neither Value nor Formula is applicable, and the actual threshold is derived based on the highest and/or lowest values in the associated range:
See