Databar.BarFillType (Excel)

Returns or sets how a data bar is filled with color. Possible return values are xlDataBarFillGradient - The data bar is filled with a color gradient, xlDataBarFillSolid - The data bar is filled with solid color.

The default value of the BarFillType property is xlDataBarFillGradient.

ActiveCell.FormatConditions(1).BarFillType = xlDataBarFillGradient