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.

Range("A1:A10").Select 
Range("A1:A10").Activate 
 
Set myDataBar = Selection.FormatConditions.AddDatabar 
myDataBar.BarFillType = xlDataBarFillSolid

Community Additions

ADD
Show:
© 2014 Microsoft