Excel.Interfaces.IconSetConditionalFormatData interface

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

Properties

criteria

An array of criteria and icon sets for the rules and potential custom icons for conditional icons. Note that for the first criterion only the custom icon can be modified, while type, formula, and operator will be ignored when set.

reverseIconOrder

If true, reverses the icon orders for the icon set. Note that this cannot be set if custom icons are used.

showIconOnly

If true, hides the values and only shows icons.

style

If set, displays the icon set option for the conditional format.

Property Details

criteria

An array of criteria and icon sets for the rules and potential custom icons for conditional icons. Note that for the first criterion only the custom icon can be modified, while type, formula, and operator will be ignored when set.

criteria?: Excel.ConditionalIconCriterion[];

Property Value

Remarks

[ API set: ExcelApi 1.6 ]

reverseIconOrder

If true, reverses the icon orders for the icon set. Note that this cannot be set if custom icons are used.

reverseIconOrder?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

showIconOnly

If true, hides the values and only shows icons.

showIconOnly?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

style

If set, displays the icon set option for the conditional format.

style?: Excel.IconSet | "Invalid" | "ThreeArrows" | "ThreeArrowsGray" | "ThreeFlags" | "ThreeTrafficLights1" | "ThreeTrafficLights2" | "ThreeSigns" | "ThreeSymbols" | "ThreeSymbols2" | "FourArrows" | "FourArrowsGray" | "FourRedToBlack" | "FourRating" | "FourTrafficLights" | "FiveArrows" | "FiveArrowsGray" | "FiveRating" | "FiveQuarters" | "ThreeStars" | "ThreeTriangles" | "FiveBoxes";

Property Value

Excel.IconSet | "Invalid" | "ThreeArrows" | "ThreeArrowsGray" | "ThreeFlags" | "ThreeTrafficLights1" | "ThreeTrafficLights2" | "ThreeSigns" | "ThreeSymbols" | "ThreeSymbols2" | "FourArrows" | "FourArrowsGray" | "FourRedToBlack" | "FourRating" | "FourTrafficLights" | "FiveArrows" | "FiveArrowsGray" | "FiveRating" | "FiveQuarters" | "ThreeStars" | "ThreeTriangles" | "FiveBoxes"

Remarks

[ API set: ExcelApi 1.6 ]