[]
        
(Showing Draft Content)

GrapeCity.Spreadsheet.ClassicCfRuleType

ClassicCfRuleType Enum

Namespace: GrapeCity.Spreadsheet
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public enum ClassicCfRuleType
Public Enum ClassicCfRuleType

Fields

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.