Share via


IconCriterion.Value Property

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

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 IconCriterion
Dim value As Object

value = instance.Value

instance.Value = value
Object Value { get; set; }

Property Value

Type: System.Object

Remarks

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

See Also

Reference

IconCriterion Interface

IconCriterion Members

Microsoft.Office.Interop.Excel Namespace