Static
$tStatic
nextReturns the total number of items in the collection.
Adds a new [[AverageConditionalFormat]] instance to this collection.
[[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.
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.
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.
A string identifying the
Adds a new [[DateTimeConditionalFormat]] instance to this collection.
[[DateTimeConditionalFormat]]
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.
A string identifying the
Adds a new [[ErrorsConditionalFormat]] instance to this collection.
A string identifying the
Adds a new [[FormulaConditionalFormat]] instance to this collection.
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.
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.
A string identifying the
Adds a new [[NoErrorsConditionalFormat]] instance to this collection.
A string identifying the
Adds a new [[OperatorConditionalFormat]] instance to this collection.
[[OperatorConditionalFormat]]
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.
[[RankConditionalFormat]]
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.
[[TextOperatorConditionalFormat]]
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.
A string identifying the
Returns true if the collection contains the condition
The condition
Gets the index of the item in the collection
Indexer
[[IndexOutOfRangeException]] If the index is negative or greater than or equal to [[count]]
Removes an item from 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