Click or drag to resize

ConditionalFormatRuleCollection Methods

The ConditionalFormatRuleCollection type exposes the following members.

Methods
  NameDescription
Public methodAdd2ColorScale
Adds a '2-Color Scale' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodAdd3ColorScale
Adds a '3-Color Scale' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodAddAboveOrBelowAverage
Adds an 'Above or Below Average' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodAddContain
Adds a 'Cells with Blanks' or 'Cells with No Blanks' or 'Cells with Errors' or 'Cells with No Errors' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodAddContainDate
Adds a 'Cells with Dates Occurring' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodAddContainText
Adds a 'Cells with Specific Text' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodAddContainValue(String, ContainValueOperator, Object)
Adds a 'Cells with Cell Value' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodAddContainValue(String, ContainValueOperator, Object, Object)
Adds a 'Cells with Cell Value' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodAddDataBar
Adds a 'Data Bar' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodAddFormula
Adds a 'Formula' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodAddIconSet
Adds an 'Icon Set' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodAddTopOrBottomRanked
Adds a 'Top or Bottom Ranked' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodAddUniqueOrDuplicate
Adds a 'Unique or Duplicate' conditional formatting rule applied to a specified sequence of references to cell ranges.
Public methodGetEnumerator
Returns an enumerator that iterates through the ConditionalFormatRuleCollection.
Public methodMove
Moves the ConditionalFormatRule at the specified index to a new location in the ConditionalFormatRuleCollection.
Public methodRemove(ConditionalFormatRule)
Removes the specified ConditionalFormatRule from the ConditionalFormatRuleCollection.
Public methodRemove(FormatCondition)
Removes a ConditionalFormatRule associated with the specified FormatCondition from the ConditionalFormatRuleCollection.
Public methodRemoveAt
Removes the ConditionalFormatRule at the specified index of the ConditionalFormatRuleCollection.
Top
See Also