Adds a new DataBarConditionalFormat instance to this collection. Syntax Parameters regionAddress A string identifying the region to which this conditional format applies. Return Value The resulting DataBarConditionalFormat instance.
Adds a new DateTimeConditionalFormat instance to this collection. Syntax Parameters regionAddress A string identifying the region to which this conditional format applies.dateOperator A FormatConditionTimePeriod which defines the time period against which cell date values are evaluated. This parameter is optional ...
Adds a new DuplicateConditionalFormat instance to this collection, configured as a duplicate value condition. Syntax Parameters regionAddress A string identifying the region to which this conditional format applies. Return Value The resulting DuplicateConditionalFormat instance. Remarks Use this method to add a co...
Adds a new ErrorsConditionalFormat instance to this collection. Syntax Parameters regionAddress A string identifying the region to which this conditional format applies. Return Value The resulting ErrorsConditionalFormat instance.
Adds a new FormulaConditionalFormat instance to this collection. Syntax Parameters regionAddress A string identifying the region to which this conditional format applies.formula The formula which is used to determine whether a cell value meets the condition criteria.cellReferenceMode A Infragistics.Documents.Excel...
Adds a new IconSetConditionalFormat instance to this collection. Syntax Parameters regionAddress A string identifying the region to which this conditional format applies.iconSet A Infragistics.Documents.Excel.FormatConditionIconSet value which identifies the icon set to use. This parameter is optional and defaults...
Adds a new NoBlanksConditionalFormat instance to this collection. Syntax Parameters regionAddress A string identifying the region to which this conditional format applies. Return Value The resulting NoBlanksConditionalFormat instance.
Adds a new NoErrorsConditionalFormat instance to this collection. Syntax Parameters regionAddress A string identifying the region to which this conditional format applies. Return Value The resulting NoErrorsConditionalFormat instance.
Adds a new OperatorConditionalFormat instance to this collection. Syntax Parameters regionAddress A string identifying the region to which this conditional format applies.conditionOperator A FormatConditionOperator value which defines the initial value of the Operator property. This parameter is optional and defau...
Adds a new RankConditionalFormat instance to this collection. Syntax Parameters regionAddress A string identifying the region to which this conditional format applies.topBottom A FormatConditionTopBottom value which determines whether the top or bottom of the ranking is evaluated. This parameter is optional and de...