Excel.Interfaces.ConditionalRangeFormatUpdateData interface

An interface for updating data on the ConditionalRangeFormat object, for use in "conditionalRangeFormat.set({ ... })".

Properties

borders

Collection of border objects that apply to the overall conditional format range.

[ API set: ExcelApi 1.6 ]

fill

Returns the fill object defined on the overall conditional format range.

[ API set: ExcelApi 1.6 ]

font

Returns the font object defined on the overall conditional format range.

[ API set: ExcelApi 1.6 ]

numberFormat

Represents Excel's number format code for the given range. Cleared if null is passed in.

[ API set: ExcelApi 1.6 ]

Property Details

borders

Collection of border objects that apply to the overall conditional format range.

[ API set: ExcelApi 1.6 ]

borders?: Excel.Interfaces.ConditionalRangeBorderCollectionUpdateData;

Property Value

fill

Returns the fill object defined on the overall conditional format range.

[ API set: ExcelApi 1.6 ]

fill?: Excel.Interfaces.ConditionalRangeFillUpdateData;

Property Value

font

Returns the font object defined on the overall conditional format range.

[ API set: ExcelApi 1.6 ]

font?: Excel.Interfaces.ConditionalRangeFontUpdateData;

Property Value

numberFormat

Represents Excel's number format code for the given range. Cleared if null is passed in.

[ API set: ExcelApi 1.6 ]

numberFormat?: any;

Property Value

any