ColorScaleCriterion.FormatColor Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

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

Returns a FormatColor object, which specifies the color assigned to the threshold of a color scale conditional format. Read-only.

expression .FormatColor

expression A variable that represents a ColorScaleCriterion object.

You can set the color of the minimum, midpoint, or maximum thresholds to any custom color by using the Color property; or use the ThemeColor property.

Show: