FormatColor Members (Excel)

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

Properties

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.

Color

Returns or sets the fill color associated with a threshold for a data bar or color scale conditional formatting rule.

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.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Parent

Returns the parent object for the specified object. Read-only.

ThemeColor

Returns or 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.

TintAndShade

Returns or sets a Single that lightens or darkens the fill color of a cell for a threshold of a data bar or color scale conditional formatting rule.