ColorScaleCriterion.Index Property (Excel)
Returns a Long value indicating which threshold the criteria represents. Read-only.
Version Information
Version Added: Excel 2007
Syntax
expression .Index
expression A variable that represents a ColorScaleCriterion object.
Remarks
For a two-color scale conditional format rule, this property will return a value of "1" for the minimum threshold and "2" for the maximum threshold. When using a three-color scale rule, the values will be "1" for the minimum, "2" for the midpoint, and "3" for the maximum thresholds.