DataBarBorder.Color Property (Excel)
Returns an object that specifies the color of the border of data bars specified by a conditional formatting rule. Read-only
Version Information
Version Added: Excel 2010
Syntax
expression .Color
expression A variable that represents a DataBarBorder object.
Return Value
Example
The following code example selects a range of cells and adds a data bar conditional formatting rule to that range. It then uses the BarBorder property to retrieve the DataBarBorder object associated with that rule, and uses the Color property of that object to retrieve the FormatColor object to set the color and tint of the data bar borders.
Range("A1:A10").Select
Range("A1:A10").Activate
Set myDataBar = Selection.FormatConditions.AddDatabar
With myDataBar.BarBorder
.Type = xlDataBarBorderSolid
.Color.ThemeColor = xlThemeColorAccent2
.Color.TintAndShade = 0
End With