Share via

ColorScaleCriterion Object Members

  • Article
Excel Developer Reference

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

Properties

  Name Description
Bb255926.properties(en-us,office.12).gif FormatColor Returns a FormatColor object which specifies the color assigned to the threshold of a color scale conditional format. Read-only.
Bb255926.properties(en-us,office.12).gif Index Returns a Long value indicating which threshold the criteria represents. Read-only.
Bb255926.properties(en-us,office.12).gif 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.
Bb255926.properties(en-us,office.12).gif Value Returns or sets the minimum, midpoint, or maximum threshold value for a color scale conditional format. Read/write Variant.