FormatConditionType

Cells with values which are greater than or less than the average value for the associated region are formatted.

Cells with no value are formatted. Note that foreground-related properties such as font colors are not applicable.

The format is based on the cell's value, which is evaluated against one or more conditions to determine whether the value meets a particular criteria.

Represents a conditional formatting rule which applies gradations to cell colors to indicate relative differences in the values of cells which belong to the associated range.

Represents a conditional formatting rule which renders a color bar inside the cell to indicate relative differences in the values of cells which belong to the associated range.

Cells with values which are duplicated (non-unique) across the associated range are formatted.

The format is applied to cells which contain an error.

The format is determined by evaluating a formula.

Represents a conditional formatting rule which displays an icon inside the cell which indicates the cell's value as relative to the highest and lowest value in the associated range.

Cells with a non-empty value are formatted.

The format is applied to cells which do not contain an error.

Cells with the top/bottom n values are formatted, where n represents a numeric, percentage, or percentile ranking. For example, this type can be used to to enable a 'top ten' condition.

The format is determined by whether the cell's value matches a literal string value.

The format is determined by whether a cell's date value falls within a given period of time.

Cells with values which are unique across the associated range are formatted.