Enum eExcelPivotTableConditionalFormattingRuleType
Conditional formatting rule types valid for pivot tables.
Namespace: OfficeOpenXml.ConditionalFormatting
Assembly: EPPlus.dll
Syntax
public enum eExcelPivotTableConditionalFormattingRuleTypeFields
| Name | Description |
|---|---|
| AboveAverage | Highlights cells that are above the average for all values in the range. |
| AboveOrEqualAverage | Highlights cells that are above or equal to the average for all values in the range. |
| AboveStdDev | Highlights cells that are above the standard deviation for all values in the range.
|
| BelowAverage | Highlights cells that are below the average for all values in the range. |
| BelowOrEqualAverage | Highlights cells that are below or equal to the average for all values in the range. |
| BelowStdDev | Highlights cells that are below the standard deviation for all values in the range. |
| Between | Highlights cells in the range between the given two formulas. |
| Bottom | Highlights cells whose values fall in the bottom N bracket as specified. |
| BottomPercent | Highlights cells whose values fall in the bottom N percent as specified. |
| ContainsBlanks | Highlights cells that are completely blank. |
| ContainsErrors | Highlights cells with formula errors. |
| DataBar | This conditional formatting rule displays a gradated data bar in the range of cells. |
| Equal | Highlights cells equal to the given formula. |
| Expression | This rule contains a formula to evaluate. When the formula result is true, the cell is highlighted. |
| FiveIconSet | This conditional formatting rule applies a 5 set icons to cells according to their values. |
| FourIconSet | This conditional formatting rule applies a 4 set icons to cells according to their values. |
| GreaterThan | Highlights cells greater than the given formula. |
| GreaterThanOrEqual | Highlights cells greater than or equal the given formula. |
| LessThan | Highlights cells less than the given formula. |
| LessThanOrEqual | Highlights cells less than or equal the given formula. |
| NotBetween | Highlights cells outside the range in given two formulas. |
| NotContainsBlanks | Highlights cells that are not blank. |
| NotContainsErrors | Highlights cells without formula errors. |
| NotEqual | . |
| ThreeColorScale | Three Color Scale (Low, Middle and High Color Scale) |
| ThreeIconSet | This conditional formatting rule applies a 3 set icons to cells according to their values. |
| Top | Highlights cells whose values fall in the top N bracket as specified. |
| TopPercent | Highlights cells whose values fall in the top N percent as specified. |
| TwoColorScale | Two Color Scale (Low and High Color Scale) |