Excel.Interfaces.IconSetConditionalFormatUpdateData interface

An interface for updating data on the IconSetConditionalFormat object, for use in iconSetConditionalFormat.set({ ... }).

Properties

criteria

An array of Criteria and IconSets 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.

[ API set: ExcelApi 1.6 ]

reverseIconOrder

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

[ API set: ExcelApi 1.6 ]

showIconOnly

If true, hides the values and only shows icons.

[ API set: ExcelApi 1.6 ]

style

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

[ API set: ExcelApi 1.6 ]

Property Details

criteria

An array of Criteria and IconSets 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.

[ API set: ExcelApi 1.6 ]

criteria?: Excel.ConditionalIconCriterion[];

Property Value

reverseIconOrder

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

[ API set: ExcelApi 1.6 ]

reverseIconOrder?: boolean;

Property Value

boolean

showIconOnly

If true, hides the values and only shows icons.

[ API set: ExcelApi 1.6 ]

showIconOnly?: boolean;

Property Value

boolean

style

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

[ API set: ExcelApi 1.6 ]

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

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" | "LinkedEntityFinanceIcon" | "LinkedEntityMapIcon"