FormatColor Object Members

Excel Developer Reference

Represents the fill color specified for a threshold of the a color scale conditional format or the color of the bar in a data bar conditional format.

Properties

  Name Description
Bb242263.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.
Bb242263.properties(en-us,office.12).gif Color Returns or sets the fill color associated with a threshold for a data bar or color scale conditional formatting rule.
Bb242263.properties(en-us,office.12).gif ColorIndex Returns or sets one of the constants of the XlColorIndex enumeration specifying if the fill color is expressed as an index value into the current color palette.
Bb242263.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242263.properties(en-us,office.12).gif ThemeColor Returns of sets one of the constants of the XlThemeColor enumeration specifying the theme color used in a threshold of a data bar or color scale conditional format.
Bb242263.properties(en-us,office.12).gif TintAndShade Returns or sets a Single that lightens or darkens the fill color of a cell for a thresholds of a data bar or color scale conditional formatting rule.