Constants which specify the manner in which cell values are compared when evaluating a AverageConditionalFormat. Syntax Members Member Description AboveAverage The cell value must be above the average for the associated range in order to meet the associated condition. AboveStandardDeviation The cell value must be ...
Constants which specify the manner in which a cell value is compared against one or more operands. Syntax Members Member Description Between The condition evaluates to true if the cell value is between the values of the two operands. Equal The condition evaluates to true if the cell value is equal to the value of ...
Constants which specify the text comparison method applied when evaluating a format condition. Syntax Members Member Description BeginsWith The string being evaluated must begin with the value to which it is being compared in order for the condition to be met. Contains The string being evaluated must match some pa...
Constants which define the manner in which a cells date/time value is compared when evaluating a DateTimeConditionalFormat. Syntax Members Member Description LastMonth The cells date/time value is compared to the month before the current one. LastSevenDays The cells date/time value meets the condition if it lies w...
Constans which identify whether a RankConditionalFormat evaluates to true for the top or bottom ranked values across the associated range. Syntax Members Member Description Bottom The cell value must fall within the bottom ranking of values for the associated range. Top The cell value must fall within the top rank...
Constants which determine the criteria for a format condition. Syntax Members Member Description Average Cells with values which are greater than or less than the average value for the associated region are formatted. Blanks Cells with no value are formatted. Note that foreground-related properties such as font co...
Constants which identify the type of value which defines the criteria for a ColorScaleCriterion or IconCriterion. Syntax Members Member Description AutomaticMaximum The longest data bar is proportional to the highest value across the associated range. Applicable only to the IconCriterion class. AutomaticMinimum Th...
Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cells value meets the criteria defined by a formula. Syntax
For a list of all members of this type, see FormulaConditionalFormat members. Public Events Name Description PropertyChanged Occurs after a property value has changed (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase) Top
Public Properties Public Methods Public Events