ColorScaleCriterion Properties (Excel)

GitHub-Mark-64px

Contribute to this content

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

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: