Version

AverageConditionalFormat Class Members

The following tables list the members exposed by AverageConditionalFormat.

Public Properties
 NameDescription
Public PropertyAboveBelowReturns or sets a value which determines the manner in which cell values are compared against the average or standard deviation for the associated range.  
Public PropertyCellFormatReturns an Infragistics.Documents.Excel.IWorksheetCellFormat interface implementation which represents the format for cells which meet the criteria associated with this condition. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionalFormatBase)
Public PropertyConditionTypeReturns a FormatConditionType value which identifies the type of condition for this instance. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public PropertyNumericStandardDeviationReturns or sets the numeric standard deviation for this condition. Applicable only when the AboveBelow property is set to 'AboveStandardDeviation' or 'BelowStandardDeviation'.  
Public PropertyPriorityReturns or sets a value which determines the order of evaluation when multiple conditional formatting rules exist. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public PropertyRegionsReturns the Infragistics.Documents.Excel.WorksheetRegion which identifies the cell range with which this condition is associated. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public PropertyStopIfTrueReturns or sets a boolean indicating whether additional formatting rules are evaluated if this rule evaluates to true. Applicable only in the case where the containing collection contains more than one element. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public PropertyWorkbookReturns a reference to the associated workbook. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public PropertyWorksheetReturns a reference to the associated worksheet. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public Methods
 NameDescription
Public MethodSetFirstPrioritySets the ConditionBase.Priority value for this rule such that it is the first condition to be evaluated. Applicable only in the case where there is more than one element contained within the associated collection. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public MethodSetLastPrioritySets the ConditionBase.Priority value for this rule such that it is the last condition to be evaluated. Applicable only in the case where there is more than one element contained within the associated ConditionalFormatCollection. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public MethodSetRegionsReplaces the existing regions with new ones (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public Events
 NameDescription
Public EventPropertyChangedOccurs after a property value has changed (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
See Also