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

Visual Basic

'Declaration
 
Public NotInheritable Class ColorScaleConditionalFormat 
   Inherits ThresholdConditionBase

C#

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: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2