Excel.FillFormat.GradientColorType.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
FillFormat.GradientColorType property (Excel)	vbaxl10.chm115013	vbaxl10.chm115013	Excel.FillFormat.GradientColorType	f8652224-753c-5491-a190-5f50d3736be1	04/26/2019	medium

FillFormat.GradientColorType property (Excel)

Returns the gradient color type for the specified fill. Read-only MsoGradientColorType.

Syntax

expression.GradientColorType

expression A variable that represents a FillFormat object.

Remarks

The msoGradientColorMixed constant is a return value only that indicates a combination of the other states in the specified range. Use the OneColorGradient, PresetGradient, or TwoColorGradient method to set the gradient type for the fill.

Example

This example sets the fill format for chart two to the same style used for chart one.

Set c1f = Charts(1).ChartArea.Fill 
If c1f.Type = msoFillGradient And _ 
        c1f.GradientColorType = msoGradientOneColor Then 
    With Charts(2).ChartArea.Fill 
        .Visible = True 
        .OneColorGradient c1f.GradientStyle, _ 
            c1f.GradientVariant, c1f.GradientDegree 
    End With 
End If

[!includeSupport and feedback]