ColorScaleCriterion Members (Excel)

Represents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format.

Properties

Name

Description

FormatColor

Returns a FormatColor object, which specifies the color assigned to the threshold of a color scale conditional format. Read-only.

Index

Returns a Long value indicating which threshold the criteria represents. Read-only.

Type

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.

Value

Returns or sets the minimum, midpoint, or maximum threshold value for a color scale conditional format. Read/write Variant.