Skip to main content
Row

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.
See Also