| Class | Description | |
|---|---|---|
 | AverageConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether a cell's value is above or below the average or standard deviation for the associated range. |
| BlanksConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's value is not set. |
| CellConditionalFormat | Represents the aggregated conditioal format for a specific cell. It is returned via the Worksheet.GetCellConditionalFormat and the WorksheetRow.GetCellConditionalFormat methods. |
| CellDataBarInfo | Exposes the information necessary for drawing a data bar for a specific cell. |
| CellIconInfo | Exposes the information necessary for drawing an icon for a specific cell. |
| ColorScaleConditionalFormat | 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. |
| ColorScaleCriterion | Defines the criterion for a ColorScaleConditionalFormat threshold. |
| ConditionalFormatBase | Abstract base class for classes which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell, based on whether the cell's value meets a logical condition. |
| ConditionalFormatCollection | Collection class for objects which derive from ConditionBase. |
| ConditionBase | Abstract base class which encapsulates the condition for a formatting rule. |
| ConditionValue | Exposes properties which define the value and its unit of measure for a conditional format threshold. |
| CriterionBase | Base class for the IconCriterion and ColorScaleCriterion classes. |
| DataBarConditionalFormat | Exposes properties which displays data bars in a Infragistics.Documents.Excel.WorksheetCell based on the cell's value as relative to the associated range. |
| DateTimeConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether a cell's date/time value falls within a given range of time. |
| DuplicateConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether a cell's value is unique or duplicated across the associated range. |
| ErrorsConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's value is in error. |
| FormulaConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's value meets the criteria defined by a formula. |
| IconCriterion | Defines the criterion for an IconSetConditionalFormat threshold. |
| IconSetConditionalFormat | Exposes properties which displays icons in a Infragistics.Documents.Excel.WorksheetCell based on the cell's value as relative to threshold values. |
| IconSetCriterionCollection | Collection class for objects of type IconCriterion. |
| NegativeBarFormat | Exposes properties which control the appearance of negative-value data bars. |
| NoBlanksConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's value is not set. |
| NoErrorsConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's value is in error. |
| OperatorConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's value meets the criteria defined by a logical operator. |
| RankConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether a cell's value is within the top or bottom rank of values across the associated range. |
| TextOperatorConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's text value meets the criteria defined by a string and a FormatConditionTextOperator value. |
| ThresholdConditionBase | Base class for the DataBarConditionalFormat, IconSetConditionalFormat, and ColorScaleConditionalFormat classes. |
| UniqueConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether a cell's value is unique across the associated range. |
| Enumeration | Description | |
|---|---|---|
 | ColorScaleCriterionThreshold | Constants which identify the threshold of a ColorScaleCriterion. |
| ColorScaleType | Constants which identify whether a ColorScaleConditionalFormat supports two or three thresholds. Used to differentiate between a 2-color and 3-color scale. |
| DataBarAxisPosition | Constants which determine the axis position for a DataBarConditionalFormat. |
| DataBarDirection | Constants which determine whether data bars are filled with a solid color or with a gradient. |
| DataBarFillType | Constants which determine whether data bars are filled with a solid color or with a gradient. |
| DataBarNegativeBarColorType | Constants which specify the manner in which the color for negative-value data bars is determined. |
| FormatConditionAboveBelow | Constants which specify the manner in which cell values are compared when evaluating a AverageConditionalFormat. |
| FormatConditionOperator | Constants which specify the manner in which a cell value is compared against one or more operands. |
| FormatConditionTextOperator | Constants which specify the text comparison method applied when evaluating a format condition. |
| FormatConditionTimePeriod | Constants which define the manner in which a cell's date/time value is compared when evaluating a DateTimeConditionalFormat. |
| FormatConditionTopBottom | Constans which identify whether a RankConditionalFormat evaluates to true for the top or bottom ranked values across the associated range. |
| FormatConditionType | Constants which determine the criteria for a format condition. |
| FormatConditionValueType | Constants which identify the type of value which defines the criteria for a ColorScaleCriterion or IconCriterion. |
| ThresholdComparison | Constants which determine the manner in which cell values are compared to the ConditionValue.Value property when conditional criteria is evaluated by an IconSetConditionalFormat. |
View on GitHub