Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Borders.TintAndShade Property

Office 2007
Returns or sets a Single that lightens or darkens a color.

Version Information
 Version Added:  Excel 2007



expression   A variable that represents a Borders object.


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

Attempting to set this property to a value less than -1 or more than 1 results in a run-time error: "The specified value is out of range." This property works for both theme colors and nontheme colors.

Community Additions

© 2015 Microsoft