Export (0) Print
Expand All

ColorScaleCriterion Members (Excel)

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

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.

Show:
© 2014 Microsoft