GrapeCity.Spreadsheet.IFormatConditions

IFormatConditions Interface

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.