XlCondFmtRuleDataBar Properties

Represents the Data Bar conditional formatting rule.

Name	Description
AxisColor	Gets or sets the color of the axis between positive and negative bars.
AxisPosition	Gets or sets the axis position in a cell.
BorderColor	Gets or sets the color of the data bar borders.
Direction	Gets or sets the direction of data bars.
FillColor	Gets or sets the data bar fill color.
GradientFill	Gets or sets whether to apply the gradient fill type.
MaxLength	Gets or sets the maximum length of the data bar.
MaxValue	Provides access to the maximum value within the cells range to which the data bat formatting rule is applied.
MinLength	Gets or sets the minimum length of the data bar.
MinValue	Provides access to the minimum value within the cell range to which the data bar conditional formatting rule is applied.
NegativeBorderColor	Gets or sets the border color of a negative data bar.
NegativeFillColor	Gets or sets the color of a negative data bar.
Priority	Specifies the priority of the conditional formatting rule. Inherited from XlCondFmtRule.
RuleType	Gets the type of the specified conditional formatting rule. Inherited from XlCondFmtRule.
ShowValues	Gets or sets whether to display cell values to which the data bar conditional formatting rule is applied.
StopIfTrue	Gets or sets whether the conditional formatting rules with lower priority can be applied. Inherited from XlCondFmtRule.