[]
Represents the conditional formats associated with a range.
public interface IFormatConditions
Public Interface IFormatConditions
Name | Description |
---|---|
Count | Returns a value that represents the number of objects in the collection. |
this[int] | Returns the conditional format specified by the zero-based index. |
Name | Description |
---|---|
Add(FormatConditionType, FormatConditionOperator, object, object) | Adds a new conditional format. |
AddAboveAverage() | Returns a new IAboveAverage object representing a conditional formatting rule for the specified range. |
AddColorScale(ColorScaleType) | 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 IDataBar 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 conditional formats associated with the represented range. |
FromJson(string) | Generates the conditional formats from the json string. |
ToJson() | Generates a json string from the conditional formats. |