Static $tStatic nextReturns the total number of items in the collection.
Adds a new AverageConditionalFormat instance to this collection.
The resulting AverageConditionalFormat.
A string identifying the
A FormatConditionAboveBelow value which defines the initial value of the AverageConditionalFormat.aboveBelow property. This parameter is optional and defaults to AboveAverage.
Adds a new BlanksConditionalFormat instance to this collection.
The resulting BlanksConditionalFormat instance.
A string identifying the
Adds a new ColorScaleConditionalFormat instance to this collection.
Note that when TwoColor is specified as the value of the 'colorScaleType' parameter, the ColorScaleConditionalFormat.midpointThreshold property is not applicable; attempting to set properties on the object returned from that property causes an exception to be thrown.
The ColorScaleConditionalFormat.minimumThreshold and ColorScaleConditionalFormat.maximumThreshold properties can be used to customize the coloring and threshold boundaries for the minimum and maximum points of the associated range.
For a 3-color scale, the ColorScaleConditionalFormat.midpointThreshold can also be used to customize the midpoint threshold boundary.
The resulting ColorScaleConditionalFormat instance.
A string identifying the
A ColorScaleType value which determines whether to add a 2-color or 3-color scale.
Adds a new DataBarConditionalFormat instance to this collection.
The resulting DataBarConditionalFormat instance.
A string identifying the
Adds a new DateTimeConditionalFormat instance to this collection.
The resulting DateTimeConditionalFormat instance.
A string identifying the
A FormatConditionTimePeriod which defines the time period against which cell date values are evaluated. This parameter is optional and defaults to Today.
Adds a new DuplicateConditionalFormat instance to this collection, configured as a duplicate value condition.
Use this method to add a condition which evaluates to true only for cell values which are non-unique across the associated range.
The resulting DuplicateConditionalFormat instance.
A string identifying the
Adds a new ErrorsConditionalFormat instance to this collection.
The resulting ErrorsConditionalFormat instance.
A string identifying the
Adds a new FormulaConditionalFormat instance to this collection.
The resulting FormulaConditionalFormat instance.
A string identifying the
The formula which is used to determine whether a cell value meets the condition criteria.
A CellReferenceMode value which specifies whether the 'formula' parameter should be interpreted as an A1 or R1C1 expression. This parameter is optional and defaults to null, in which case the Workbook.cellReferenceMode property is used.
Adds a new IconSetConditionalFormat instance to this collection.
Each constant in the FormatConditionIconSet enumeration contains either 3, 4, or 5 in its name. This number identifies the number of thresholds supported by the condition.
A three-threshold condition supports thresholds of 33%, 67%, and 100%.
A four-threshold condition supports thresholds of 25%, 50%, 75%, and 100%.
A five-threshold condition supports thresholds of 20%, 40%, 60%, 80%, and 100%.
A ColorScaleCriterion object for each threshold, is returned from the IconSetConditionalFormat.iconCriteria collection.
These objects provide the ability to customize the values for the corresponding threshold. For example, the icon that is displayed for a given index can be overridden using the IconCriterion.icon property.
The resulting IconSetConditionalFormat instance.
A string identifying the
A FormatConditionIconSet value which identifies the icon set to use. This parameter is optional and defaults to IconSet3TrafficLights1.
Adds a new NoBlanksConditionalFormat instance to this collection.
The resulting NoBlanksConditionalFormat instance.
A string identifying the
Adds a new NoErrorsConditionalFormat instance to this collection.
The resulting NoErrorsConditionalFormat instance.
A string identifying the
Adds a new OperatorConditionalFormat instance to this collection.
The resulting OperatorConditionalFormat instance.
A string identifying the
A FormatConditionOperator value which defines the initial value of the OperatorConditionalFormat.operator property. This parameter is optional and defaults to Equal.
Adds a new RankConditionalFormat instance to this collection.
A RankConditionalFormat can be used, for example, to format the "top ten" values in a given cell range.
To change the number of top or bottom values, use the RankConditionalFormat.rank property.
The resulting RankConditionalFormat instance.
A string identifying the
A FormatConditionTopBottom value which determines whether the top or bottom of the ranking is evaluated. This parameter is optional and defaults to Top.
The numeric, percentage, or percentile ranking. This parameter is optional and defaults to 10.
Adds a new TextOperatorConditionalFormat instance to this collection.
The resulting TextOperatorConditionalFormat instance.
A string identifying the
A string which determines the string against which cell text values are evaluated. This parameter is optional and defaults to null.
A FormatConditionTextOperator value which determines the manner in which cell values are compared to the 'text' value. This parameter is optional and defaults to BeginsWith.
Adds a new UniqueConditionalFormat instance to this collection, configured as a unique value condition.
Use this method to add a condition which evaluates to true only for cell values which are unique across the associated range.
The resulting UniqueConditionalFormat instance.
A string identifying the
Returns true if the collection contains the condition
The condition
Gets the index of the item in the collection
The index or -1 if the item is not in the collection
Indexer
The item at the specified index
IndexOutOfRangeException If the index is negative or greater than or equal to count
Removes an item from the collection
true is the item was removed or false if the item wasn't in the collection
Static compareStatic compareStatic equalsStatic equalsStatic getStatic getStatic getStatic referenceStatic static
Collection class for objects which derive from ConditionBase.
To enable a conditional format on aregion
of worksheet cells , add a ConditionBase-derived
instance to this collection.
This collection exposes an Add method for each type of conditional format available.
For example, to add a conditional format which is based on a value and a logical operator, use the addOperatorCondition method.
The conditional formatting classes which derive from ConditionalFormatBase expose aCellFormat property, which
in turn exposes properties which control the visual attributes of cells which meet the
criteria defined by the condition. This format is applied to cells with a value which
passes the condition.
See