DataBarConditionalFormatting Properties

Represents a 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 data bar border color.
Color	Gets or sets the color associated with data bars in the data bar conditional format.
Direction	Gets or sets the direction of data bars.
GradientFill	Gets or sets whether the gradient fill is applied to data bars.
HighBound	Returns the ConditionalFormattingValue object that specifies how the longest bar is evaluated for the data bar conditional format.
LowBound	Returns the ConditionalFormattingValue object that specifies how the shortest bar is evaluated for the data bar conditional format.
MaxLength	Gets or sets the maximum length of the data bar, as a percentage of the cell width.
MinLength	Gets or sets the minimum length of the data bar, as a percentage of the cell width.
NegativeBarBorderColor	Gets or sets the negative bar border color.
NegativeBarColor	Gets or sets the negative bar fill color.
Priority	Specifies the priority of the conditional formatting rule. Inherited from ConditionalFormatting.
Range	Gets or sets the range of cells to which the conditional formatting rule is applied. Inherited from ConditionalFormatting.
Ranges	Obsolete. Gets or sets a collection of ranges, to which the conditional format is applied. Inherited from ConditionalFormatting.
ShowValue	Indicates whether to show the values of cells to which the data bar conditional formatting rule is applied.
StopIfTrue	Specifies whether the rules with lower priority can be applied. Inherited from ConditionalFormatting.