Excel.Interfaces.ColorScaleConditionalFormatLoadOptions interface
Represents the color scale criteria for conditional formatting.
Remarks
Properties
$all | Specifying |
criteria | The criteria of the color scale. Midpoint is optional when using a two point color scale. |
three |
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
criteria
The criteria of the color scale. Midpoint is optional when using a two point color scale.
criteria?: boolean;
Property Value
boolean
Remarks
threeColorScale
If true
, the color scale will have three points (minimum, midpoint, maximum), otherwise it will have two (minimum, maximum).
threeColorScale?: 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