Version Information
Version Added: Excel

Remarks

The ColorStop collection allows you to set properties for the cell fill including , , .

Example
The following example shows how to apply properties to the ColorStop.

Visual Basic for Applications 
With Selection.Interior .Pattern = xlPatternLinearGradient .Gradient.Degree = 135 .Gradient.ColorStops.Clear End With With Selection.Interior.Gradient.ColorStops.Add(0) .ThemeColor = xlThemeColorDark1 .TintAndShade = 0 End With With Selection.Interior.Gradient.ColorStops.Add(0.5) .ThemeColor = xlThemeColorAccent1 .TintAndShade = 0 End With With Selection.Interior.Gradient.ColorStops.Add(1) .ThemeColor = xlThemeColorDark1 .TintAndShade = 0 End With

See also: