[]
Represents the collection of conditional formats for a single range.
public interface IFormatConditions
Public Interface IFormatConditions
Name | Description |
---|---|
Count | Gets the number of format conditions. |
this[int] | Gets the IFormatCondition object at the specified index. |
Name | Description |
---|---|
Add(ContainsOperator, string) | Adds a new conditional format. |
Add(FormatConditionType, FormatConditionOperator, string, string, ContainsOperator, TimePeriods) | Adds a new conditional format. |
Add(TimePeriods) | Adds a new conditional format. |
AddAboveAverage() | Returns a new IAboveAverage object representing a conditional formatting rule for the specified range. |
AddColorScale(int) | Returns a new IColorScale object representing a conditional formatting rule that uses gradations in cell colors to indicate relative differences in the values of cells included in a selected range. |
AddDatabar() | Returns a Databar object representing a data bar conditional formatting rule for the specified range. |
AddIconSetCondition() | Returns a new IIconSetCondition object which represents an icon set conditional formatting rule for the specified range. |
AddTop10() | Returns a ITop10 object representing a conditional formatting rule for the specified range. |
AddUniqueValues() | Returns a new IUniqueValues object representing a conditional formatting rule for the specified range. |
Delete() | Deletes all format conditions. |