ExcelScript.ConditionalDataBarNegativeFormat interface

Package:

ExcelScript

Represents a conditional format for the negative side of the data bar.

Methods

getBorderColor()	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.
getFillColor()	HTML color code representing the fill color, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange").
getMatchPositiveBorderColor()	Specifies if the negative data bar has the same border color as the positive data bar.
getMatchPositiveFillColor()	Specifies if the negative data bar has the same fill color as the positive data bar.
setBorderColor(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.
setFillColor(fillColor)	HTML color code representing the fill color, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange").
setMatchPositiveBorderColor(matchPositiveBorderColor)	Specifies if the negative data bar has the same border color as the positive data bar.
setMatchPositiveFillColor(matchPositiveFillColor)	Specifies if the negative data bar has the same fill color as the positive data bar.

Method Details

getBorderColor()

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.

getBorderColor(): string;

Returns

string

getFillColor()

HTML color code representing the fill color, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange").

getFillColor(): string;

Returns

string

getMatchPositiveBorderColor()

Specifies if the negative data bar has the same border color as the positive data bar.

getMatchPositiveBorderColor(): boolean;

Returns

boolean

getMatchPositiveFillColor()

Specifies if the negative data bar has the same fill color as the positive data bar.

getMatchPositiveFillColor(): boolean;

Returns

boolean

setBorderColor(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.

setBorderColor(borderColor: string): void;

Parameters

borderColor

string

Returns

void

setFillColor(fillColor)

HTML color code representing the fill color, in the form #RRGGBB (e.g., "FFA500") or as a named HTML color (e.g., "orange").

setFillColor(fillColor: string): void;

Parameters

fillColor

string

Returns

void

setMatchPositiveBorderColor(matchPositiveBorderColor)

Specifies if the negative data bar has the same border color as the positive data bar.

setMatchPositiveBorderColor(matchPositiveBorderColor: boolean): void;

Parameters

matchPositiveBorderColor

boolean

Returns

void

setMatchPositiveFillColor(matchPositiveFillColor)

Specifies if the negative data bar has the same fill color as the positive data bar.

setMatchPositiveFillColor(matchPositiveFillColor: boolean): void;

Parameters

matchPositiveFillColor

boolean

Returns

void