The following tables list the members exposed by ConditionalFormatting.
Public Constructors
| Name | Description | |
|---|---|---|
 | ConditionalFormatting Constructor | Overloaded. |
Public Properties
| Name | Description | |
|---|---|---|
 | AverageValue | Gets the average value. |
| ContainsCalcError | Gets a value indicating whether the conditional formatting range(s) contains CalcError value. |
| Count | Gets the number of elements contained in the ICollection. |
| DoubleValues | Gets all values. |
| IsReadOnly | Gets a value that indicates whether the ICollection is read-only. |
| Ranges | Gets the ranges that the conditional formatting applied. |
| Rules | Gets the rules. |
| StandardDeviation | Gets the standard deviation. |
| ValuesCount | Gets the ranges value count. |
Public Methods
| Name | Description | |
|---|---|---|
 | Add | Adds an item to the ICollection. |
| AddRange | Adds the elements of the specified IConditionalFormattingRule collection to the ConditionalFormatting object. |
| Clear | Removes all items from the ICollection. |
| Contains | Determines whether the ICollection contains a specific value. |
| CopyTo | Copies the items to a compatible one-dimensional array, starting at the specified index of the target array. |
| Evaluate | Overloaded. Evaluates the specified formula. |
| GetComparedValue | Gets the compare value. |
| GetEnumerator | Returns an enumerator that iterates through the collection. |
| GetValue | Gets the value. |
| IndexOf | The index of the item. |
| NotifyFormulaChanged | Notifies the ConditionalFormatting object that the formula in the conditional formatting rule has changed. |
| NotifyRequiresChanged | Notifies when the requirements have changed. |
| Remove | Removes the first occurrence of a specific object from the ICollection. |
Public Events
| Name | Description | |
|---|---|---|
 | Changed | Occurs after a conditional formatting rule has been changed. |
| ConditionalFormattingSplit | Occurs when the conditional formatting needs to be split due to an internal change. |