# ConditionalFormatType ```csharp public enum ConditionalFormatType ``` Namespace `SharpCell` · package `SharpCell` What a conditional format looks at, as Excel's New Formatting Rule dialog offers it. ## Values | Name | Value | Description | |---|---|---| | `CellValue` | 0 | The cell's value compared with formulas: Highlight Cells Rules > Greater Than and the others. | | `Expression` | 1 | Cells for which a formula is true: Use a formula to determine which cells to format. | | `Top` | 2 | The highest values of the ranges: Top/Bottom Rules > Top 10 Items or Top 10%. | | `Bottom` | 3 | The lowest values of the ranges. | | `AboveAverage` | 4 | Values above the average of the ranges. | | `BelowAverage` | 5 | Values below the average of the ranges. | | `DuplicateValues` | 6 | Values that appear more than once in the ranges. | | `UniqueValues` | 7 | Values that appear once in the ranges. | | `ContainsText` | 8 | Text containing [ConditionalFormat.Text](SharpCell.ConditionalFormat.md#text), ignoring case. | | `NotContainsText` | 9 | Text not containing [ConditionalFormat.Text](SharpCell.ConditionalFormat.md#text). | | `BeginsWith` | 10 | Text beginning with [ConditionalFormat.Text](SharpCell.ConditionalFormat.md#text). | | `EndsWith` | 11 | Text ending with [ConditionalFormat.Text](SharpCell.ConditionalFormat.md#text). | | `Blanks` | 12 | Empty cells, or cells holding only spaces. | | `NoBlanks` | 13 | Cells that are not blank. | | `Errors` | 14 | Cells holding an error. | | `NoErrors` | 15 | Cells not holding an error. | | `TimePeriod` | 16 | Dates in a period around today: A Date Occurring. | | `ColorScale` | 17 | A colour scale, read from a file; every number gets a colour of its own, which SharpCell does not work out. | | `DataBar` | 18 | Data bars, read from a file. | | `IconSet` | 19 | An icon set, read from a file. |