Excel.Interfaces.IconSetConditionalFormatUpdateData interface
Warning
This API is now deprecated.
An interface for updating data on the IconSetConditionalFormat
object, for use in iconSetConditionalFormat.set({ ... })
.
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. |
reverse |
If |
show |
If |
style | If set, displays the icon set option for the conditional format. |
Property Details
criteria
Warning
This API is now deprecated.
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
reverseIconOrder
Warning
This API is now deprecated.
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
showIconOnly
Warning
This API is now deprecated.
If true
, hides the values and only shows icons.
showIconOnly?: boolean;
Property Value
boolean
Remarks
style
Warning
This API is now deprecated.
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
Office Add-ins