GrapeCity.Spreadsheet.ClassicCfRuleType

ClassicCfRuleType Enum

specifies the type of the classic conditional formatting rule.

public enum ClassicCfRuleType

Public Enum ClassicCfRuleType

Name	Description
Average	This conditional formatting rule highlights cells that are above or below the average for all values in the range.
BeginsWith	This conditional formatting rule highlights cells in the range that begin with the given text.
CellIs	This conditional formatting rule compares a cell value to a formula calculated result, using an operator.
ContainsBlank	This conditional formatting rule highlights cells that are completely blank.
ContainsErrors	This conditional formatting rule highlights cells with formula errors.
ContainsNoBlank	This conditional formatting rule highlights cells that are not blank.
ContainsNoErrors	This conditional formatting rule highlights cells without formula errors.
ContainsNoText	This conditional formatting rule highlights cells that do not contain given text.
ContainsText	This conditional formatting rule highlights cells containing given text.
DuplicateValues	This conditional formatting rule highlights duplicated values.
EndsWith	This conditional formatting rule highlights cells ending with given text.
Expression	This conditional formatting rule contains a formula to evaluate.
TimePeriod	This conditional formatting rule highlights cells containing dates in the specified time period.
Top10	This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
UniqueValues	This conditional formatting rule highlights unique values in the range.