FillFormat.OneColorGradient Method (Excel)

Sets the specified fill to a one-color gradient.

Syntax

expression .OneColorGradient(Style, Variant, Degree)

expression A variable that represents a FillFormat object.

Parameters

Name

Required/Optional

Data Type

Description

Style

Required

MsoGradientStyle

The gradient style.

Variant

Required

Integer

The gradient variant. Can be a value from 1 through 4, corresponding to one of the four variants on the Gradient tab in the Fill Effects dialog box. If GradientStyle is msoGradientFromCenter, the Variant argument can only be 1 or 2.

Degree

Required

Single

The gradient degree. Can be a value from 0.0 (dark) through 1.0 (light).

See Also

Concepts

FillFormat Object

FillFormat Object Members