ConditionalFormatType

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, ignoring case.
`NotContainsText`	9	Text not containing ConditionalFormat.Text.
`BeginsWith`	10	Text beginning with ConditionalFormat.Text.
`EndsWith`	11	Text ending with ConditionalFormat.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.