FormatConditionCollection Methods

The FormatConditionCollection type exposes the following members.

Methods
  NameDescription
Public methodAdd
Adds a formatting condition and effected cell rang to the FormatConditions The FormatConditions can contain up to three conditional formats. References to the other sheets are not allowed in the formulas of conditional formattin
Public methodAddArea
Adds a conditional formatted cell range.
Public methodAddCondition(FormatConditionType)
Add a format condition.
Public methodAddCondition(FormatConditionType, OperatorType, String, String)
Adds a formatting condition.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetCellArea
Gets the conditional formatted cell range by index.
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodRemoveArea(Int32)
Removes conditional formatted cell range by index.
Public methodRemoveArea(Int32, Int32, Int32, Int32)
Remove conditional formatting int the range.
Public methodRemoveCondition
Removes the formatting condition by index.
Public methodToString (Inherited from Object.)
See Also