Databar.BarFillType Property (Excel)

Returns or sets how a data bar is filled with color. Read/write

Version Added: Excel 2010

expression .BarFillType

expression A variable that represents a Databar object.

Return Value

The default value of the BarFillType property is xlDataBarFillGradient.

The following code example selects a range of cells, adds a data bar conditional formatting rule to that range, and then sets the data bar's fill color to solid.

Set myDataBar = Selection.FormatConditions.AddDatabar 
myDataBar.BarFillType = xlDataBarFillSolid