ColorScaleCriterion Members (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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: