TopBottomRule Members

Fields

Name Description
AboveAverage

The format is applied to cells whose values are above the average value for the field.

BelowAverage

The format is applied to cells whose values are below the average value for the field.

BottomItems

The format is applied to cells whose values are the lowest for the field. The number of cells is specified by the TopBottomRuleFormatCondition.Threshold property.

BottomPercent

The format is applied to cells whose values are the lowest for the field. The percentage of cells is specified by the TopBottomRuleFormatCondition.Threshold property.

TopItems

The format is applied to cells whose values are the largest for the field. The number of cells is specified by the TopBottomRuleFormatCondition.Threshold property.

TopPercent

The format is applied to cells whose values are the largest for the field. The percentage of cells is specified by the TopBottomRuleFormatCondition.Threshold property.