Version

ColorScaleConditionalFormat Class

Exposes properties which control the coloring of a Infragistics.Documents.Excel.WorksheetCell based on the cell's value as relative to minimum, midpoint, and maximum threshold values.
Syntax
public sealed class ColorScaleConditionalFormat : ThresholdConditionBase 
Remarks

This class support either a 2-color or 3-color scale, as determined by the value of the colorScaleType parameter of the constructor.

For 2-color scales, cells in the associated range are colored based on how their value relates to the minimum and maximum thresholds.

For 3-color scales, cells in the associated range are colored based on how their value relates to the minimum, midpoint, and maximum thresholds.

This class supports a maximum of three separate and distinct color thresholds.

Specifying only one threshold is not supported and may result in unexpected behavior.

If this instance is created as a 2-color scale, the MidpointThreshold property is not applicable. Attempting to set a property on the object returned from the MidpointThreshold property in this case will cause an exception to be thrown.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+

See Also