FillFormat.Solid Method (Excel)

Sets the specified fill to a uniform color. Use this method to convert a gradient, textured, patterned, or background fill back to a solid fill.

Syntax

expression .Solid

expression A variable that represents a FillFormat object.

Example

This example converts all fills on myDocument to uniform red fills.

Set myDocument = Worksheets(1) 
For Each s In myDocument.Shapes 
 With s.Fill 
 .Solid 
 .ForeColor.RGB = RGB(255, 0, 0) 
 End With 
Next

See Also

Concepts

FillFormat Object

FillFormat Object Members