IconCriterion.Value Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns or sets the threshold value for an icon in a conditional format. Read/write Variant.

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

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.

Applies to