ExcelConditionalFormatsCollection Methods |
The ExcelConditionalFormatsCollection type exposes the following members.
Methods| | Name | Description |
|---|
 | AddCellValueRule(ExcelConditionalFormatOperator, String) |
Adds a rule that formats the cells whose value meets a comparison with a value, for example greater than 100.
Set the font and fill of the cells that meet the condition with the properties of the returned object.
|
 | AddCellValueRule(ExcelConditionalFormatOperator, String, String) |
Adds a rule that formats the cells whose value meets a comparison with one or two values, for example between 10 and 20.
Set the font and fill of the cells that meet the condition with the properties of the returned object.
|
 | AddColorScale(Color, Color) |
Adds a two color scale: the cell with the lowest value gets the minimum color, the cell with the highest value
gets the maximum color and the other cells get a color in between.
|
 | AddColorScale(Color, Color, Color) |
Adds a three color scale: the cell with the lowest value gets the minimum color, the cells at the 50th
percentile get the midpoint color, the cell with the highest value gets the maximum color and the other
cells get a color in between.
|
 | AddDataBar |
Adds a data bar rule: each cell displays a bar with a length proportional to its value, from the lowest to
the highest value of the range.
|
 | AddFormulaRule |
Adds a rule that formats the cells for which a formula evaluates to TRUE, for example "$C2>$D2".
The relative references in the formula are relative to the top left cell of the range, so that each cell
evaluates the formula for its own row or column. Set the font and fill of the cells that meet the condition
with the properties of the returned object.
|
 | AddIconSet |
Adds an icon set rule: each cell displays an icon chosen by its value. The range of values is divided in
equal percent intervals, one for each icon of the set.
|
 | Clear |
Removes all the conditional format rules of the range.
|
 | GetEnumerator |
Gets the collection enumerator
|
 | Remove |
Removes the specified conditional format rule from the rules of the range. The rule must be one of the
rules of this range, returned by this collection or by the method that added it. A rule object returned
before another rule of the range was removed or changed through a different collection object must be
taken again from ConditionalFormats.
|
 | RemoveAt |
Removes the conditional format rule at the specified index from the rules of the range. The other rules of
the range and the rules of the other ranges are kept. The rules after the removed one move one position
down in the collection.
|
Top
See Also