Edit

DataBarBorder.Color property (Excel)

  • Article

Returns an object that specifies the color of the border of data bars specified by a conditional formatting rule. Read-only.

Syntax

expression.Color

expression A variable that represents a DataBarBorder object.

Return value

FormatColor

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.