Color ScaleCriterion Properties

Name

Returns

Description

FormatColor Color

Format

Returns a FormatColor object, which defines the color assigned to the specified color scale threshold. Read-only

Index

Long

Returns a value that represents the threshold for the criteria. For two-color scales, the index values will be 1 for the minimum threshold and 2 for the maximum threshold. For three-color scales, the values will be 1 for the minimum threshold, 2 for the midpoint, and 3 for the maximum. Read-only

Type

ValueTypes

xlCondition

Specifies how the threshold values for a color scale conditional format are determined (number, percent, formula, or percentile). This property will return an xlCon-ditionValueTypes constant

Value

Variant

Set/Get the value for the minimum, midpoint, and maximum thresholds in a color scale conditional formatting rule

ColorStop Object and ColorStops Collection

0 0

Post a comment