Edit

Share via

Excel.Interfaces.ConditionalRangeFormatData interface

  • Reference
Package:
excel

An interface describing the data returned by calling conditionalRangeFormat.toJSON().

Properties

borders

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

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

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

Represents Excel's number format code for the given range. For more information about Excel number formatting, see Number format codes. Cleared if null is passed in.

Property Details

borders

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

borders?: Excel.Interfaces.ConditionalRangeBorderData[];

Property Value

Excel.Interfaces.ConditionalRangeBorderData[]

Remarks

[ API set: ExcelApi 1.6 ]

fill

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

fill?: Excel.Interfaces.ConditionalRangeFillData;

Property Value

Excel.Interfaces.ConditionalRangeFillData

Remarks

[ API set: ExcelApi 1.6 ]

font

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

font?: Excel.Interfaces.ConditionalRangeFontData;

Property Value

Excel.Interfaces.ConditionalRangeFontData

Remarks

[ API set: ExcelApi 1.6 ]

numberFormat

Represents Excel's number format code for the given range. For more information about Excel number formatting, see Number format codes. Cleared if null is passed in.

numberFormat?: any;

Property Value

any

Remarks

[ API set: ExcelApi 1.6 ]