Excel.Interfaces.ConditionalRangeFormatLoadOptions interface
A format object encapsulating the conditional formats range's font, fill, borders, and other properties.
Remarks
[Api set: ExcelApi 1.6]
Properties
| $all | Specifying |
| 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. |
| number |
Represents Excel's number format code for the given range. For more information about Excel number formatting, see Number format codes. Cleared if |
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
borders
Collection of border objects that apply to the overall conditional format range.
borders?: Excel.Interfaces.ConditionalRangeBorderCollectionLoadOptions;Property Value
Remarks
[Api set: ExcelApi 1.6]
fill
Returns the fill object defined on the overall conditional format range.
fill?: Excel.Interfaces.ConditionalRangeFillLoadOptions;Property Value
Remarks
[Api set: ExcelApi 1.6]
font
Returns the font object defined on the overall conditional format range.
font?: Excel.Interfaces.ConditionalRangeFontLoadOptions;Property Value
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?: boolean;Property Value
boolean
Remarks
[Api set: ExcelApi 1.6]