Enum ConditionalFormatType

Defines the conditional format types supported by the spreadsheet. Includes highlight cells rules, top/bottom rules, data bars, color scales, and icon sets.

Namespace: Syncfusion.Blazor.Spreadsheet
Assembly: Syncfusion.Blazor.Spreadsheet.dll
Syntax
public enum ConditionalFormatType
Remarks

Use these values with the conditional formatting APIs to specify which rule to apply to a range.

  • GreaterThan - Highlight Cells rules that compare cell values to a threshold.
  • Top10Items - Top/Bottom rules that mark items based on rank or percentage.
  • BlueDataBar - Data bar rules that render value-proportional bars inside cells.
  • GreenYellowRedColorScale - Color scale rules that apply a gradient across two or three colors based on value.
  • ThreeArrows - Icon set rules that add icons to cells depending on thresholds.

Fields

Name Description
AboveAverage

Highlights cells with values above the average of the range.
BelowAverage

Highlights cells with values below the average of the range.
Between

Highlights cells with values falling within a specified range.
BlueDataBar

Data bar visualization with blue fill color.
BlueWhiteRedColorScale

Two-color scale (Blue -> White -> Red).
Bottom10Items

Highlights the bottom N items in the range by value rank.
Bottom10Percentage

Highlights the bottom N percent of items in the range by value.
ContainsText

Highlights cells containing specified text.
DateOccur

Highlights cells containing dates matching a specified time period.
Duplicate

Highlights cells with duplicate values within the evaluated range.
EqualTo

Highlights cells with values equal to a specified value.
FiveArrows

Five-arrow icon set with colored indicators.
FiveArrowsGray

Five-arrow icon set with grayscale coloring.
FiveBoxes

Five-box icon set for level or stage representation.
FiveQuarters

Five-quarters icon set for fractional representation.
FiveRating

Five-star rating icon set.
FourArrows

Four-arrow icon set with colored indicators.
FourArrowsGray

Four-arrow icon set with grayscale coloring.
FourRating

Four-star rating icon set.
FourRedToBlack

Four-icon set progressing from red to black.
FourTrafficLights

Four traffic light icon set.
GreaterThan

Highlights cells with values greater than a specified threshold.
GreenDataBar

Data bar visualization with green fill color.
GreenWhiteColorScale

Two-color scale (Green -> White).
GreenWhiteRedColorScale

Three-color scale (Green -> White -> Red).
GreenYellowColorScale

Two-color scale (Green -> Yellow).
GreenYellowRedColorScale

Three-color scale (Green -> Yellow -> Red).
LessThan

Highlights cells with values less than a specified threshold.
LightBlueDataBar

Data bar visualization with light blue fill color.
OrangeDataBar

Data bar visualization with orange fill color.
PurpleDataBar

Data bar visualization with purple fill color.
RedDataBar

Data bar visualization with red fill color.
RedWhiteBlueColorScale

Two-color scale (Red -> White -> Blue).
RedWhiteColorScale

Two-color scale (Red -> White).
RedWhiteGreenColorScale

Three-color scale (Red -> White -> Green).
RedYellowGreenColorScale

Three-color scale (Red -> Yellow -> Green).
ThreeArrows

Three-arrow icon set with colored indicators.
ThreeArrowsGray

Three-arrow icon set with grayscale coloring.
ThreeFlags

Three-flag icon set for categorization.
ThreeSigns

Three-sign icon set with caution-style icons.
ThreeStars

Three-star icon set for rating representation.
ThreeSymbols

Three-symbol icon set with colored symbols.
ThreeSymbols2

Alternative three-symbol icon set with colored symbols.
ThreeTrafficLights1

Three traffic light icon set with standard coloring.
ThreeTrafficLights2

Three traffic light icon set with alternate coloring.
ThreeTriangles

Three-triangle icon set for direction or trend indication.
Top10Items

Highlights the top N items in the range by value rank.
Top10Percentage

Highlights the top N percent of items in the range by value.
Unique

Highlights cells with unique values within the evaluated range.
WhiteGreenColorScale

Two-color scale (White -> Green).
WhiteRedColorScale

Two-color scale (White -> Red).
YellowGreenColorScale

Two-color scale (Yellow -> Green).