Excel.Interfaces.ConditionalDataBarNegativeFormatUpdateData interface

An interface for updating data on the ConditionalDataBarNegativeFormat object, for use in conditionalDataBarNegativeFormat.set({ ... }).

Properties

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.

fillColor

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

matchPositiveBorderColor

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

matchPositiveFillColor

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

Property Details

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?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.6 ]

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?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.6 ]

matchPositiveBorderColor

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

matchPositiveBorderColor?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

matchPositiveFillColor

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

matchPositiveFillColor?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]