Share via


FormatColor.TintAndShade Property

Excel Developer Reference

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