ColorScaleCriterion.Value Property
Returns or sets the minimum, midpoint, or maximum threshold value for a color scale conditional format. Read/write.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property Value As Object
Get
Set
'Usage
Dim instance As ColorScaleCriterion
Dim value As Object
value = instance.Value
instance.Value = value
Object Value { get; set; }
Property Value
Type: System.Object
Object
Remarks
You can set the value only if the ColorScaleCriterion.Type property for the conditional format is set to one of the following constants: xlConditionValueNumber, xlConditionValuePercent, xlConditionValuePercentile, or xlConditionValueFormula.
If the type of threshold is a formula, you can set the formula as a String. The formula must return a single number.