Excel.Interfaces.ConditionalDataBarNegativeFormatLoadOptions interface
Represents a conditional format for the negative side of the data bar.
Properties
| $all | Specifying |
| border |
HTML color code representing the color of the border line, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange"). Value is "" (an empty string) if no border is present or set. |
| fill |
HTML color code representing the fill color, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange"). |
| match |
Specifies if the negative data bar has the same border color as the positive data bar. |
| match |
Specifies if the negative data bar has the same fill color as the positive data bar. |
Property Details
$all
Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
$all?: boolean;Property Value
boolean
borderColor
HTML color code representing the color of the border line, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange"). Value is "" (an empty string) if no border is present or set.
borderColor?: boolean;Property Value
boolean
Remarks
fillColor
HTML color code representing the fill color, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange").
fillColor?: boolean;Property Value
boolean
Remarks
matchPositiveBorderColor
Specifies if the negative data bar has the same border color as the positive data bar.
matchPositiveBorderColor?: boolean;Property Value
boolean
Remarks
matchPositiveFillColor
Specifies if the negative data bar has the same fill color as the positive data bar.
matchPositiveFillColor?: boolean;Property Value
boolean