ConditionalRangeFormat Object (JavaScript API for Excel)

A format object encapsulating the conditional formats range's font, fill, borders, and other properties.

Properties

Property Type Description Req. Set
numberFormat object Represents Excel's number format code for the given range. Cleared if null is passed in. 1.6

See property access examples.

Relationships

Relationship Type Description Req. Set
borders ConditionalRangeBorderCollection Collection of border objects that apply to the overall conditional format range. Read-only. 1.6
fill ConditionalRangeFill Returns the fill object defined on the overall conditional format range. Read-only. 1.6
font ConditionalRangeFont Returns the font object defined on the overall conditional format range. Read-only. 1.6

Methods

None