FormatColor.TintAndShade Property (Excel)

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.

Version Information

Version Added: Excel 2007

Syntax

expression .TintAndShade

expression A variable that represents a FormatColor object.

Remarks

You can enter a number from -1 (darkest) to 1 (lightest) for the TintAndShade property. Zero (0) is neutral.

See Also

Concepts

FormatColor Object Members

FormatColor Object