Excel.Interfaces.ConditionalRangeFormatLoadOptions interface
A format object encapsulating the conditional formats range's font, fill, borders, and other properties.
Remarks
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 LoadOptions loads all the scalar properties (e.g.: Range.address
) but not the navigational properties (e.g.: 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
fill
Returns the fill object defined on the overall conditional format range.
fill?: Excel.Interfaces.ConditionalRangeFillLoadOptions;
Property Value
Remarks
font
Returns the font object defined on the overall conditional format range.
font?: Excel.Interfaces.ConditionalRangeFontLoadOptions;
Property Value
Remarks
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
Office Add-ins
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for