ColorScaleCriterion.Type Property

Returns one of the constants of the XlConditionValueTypes enumeration, which specifies how the threshold values for a data bar or color scale conditional format are determined. Read-only.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property Type As XlConditionValueTypes
    Get
    Set
'Usage
Dim instance As ColorScaleCriterion
Dim value As XlConditionValueTypes

value = instance.Type

instance.Type = value
XlConditionValueTypes Type { get; set; }

Property Value

Type: Microsoft.Office.Interop.Excel.XlConditionValueTypes
XlConditionValueTypes

Remarks

The type of threshold value for a data bar or color scale can be a number, percent, formula, or percentile. Setting the type to percentile will use the Percentile function in Excel to determine the threshold value.

See Also

Reference

ColorScaleCriterion Interface

ColorScaleCriterion Members

Microsoft.Office.Interop.Excel Namespace