ColorScaleCriterion.Value Property

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Returns or sets the minimum, midpoint, or maximum threshold value for a color scale conditional format. Read/write.

public:
 property System::Object ^ Value { System::Object ^ get(); void set(System::Object ^ value); };

public object Value { get; set; }

Public Property Value As Object

Property Value

Object

Object

Remarks

You can set the value only if the 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.