Click or drag to resize

ExcelConditionalFormatsCollection Methods

The ExcelConditionalFormatsCollection type exposes the following members.

Methods
 NameDescription
Public methodAddCellValueRule(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.
Public methodAddCellValueRule(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.
Public methodAddColorScale(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.
Public methodAddColorScale(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.
Public methodAddDataBar 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.
Public methodAddFormulaRule 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.
Public methodAddIconSet 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.
Public methodClear Removes all the conditional format rules of the range.
Public methodGetEnumerator Gets the collection enumerator
Public methodRemove 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.
Public methodRemoveAt 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