FormatConditionAppearanceType Enum

Lists values used to specify style settings used in conditional formatting.

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v22.1.Core.dll

Declaration

C#

public enum FormatConditionAppearanceType

VB.NET

Public Enum FormatConditionAppearanceType

Members

Name	Description
None	Style settings are not changed.
Custom	A custom appearance. If the AppearanceSettings.AppearanceType is set to Custom, specify appearance settings manually using the AppearanceSettings.BackColor, AppearanceSettings.ForeColor, AppearanceSettings.FontFamily and AppearanceSettings.FontStyle properties.
PaleRed	The Pale Red color.
PaleYellow	The Pale Yellow color.
PaleGreen	The Pale Green color.
PaleBlue	The Pale Blue color.
PalePurple	The Pale Purple color.
PaleCyan	The Pale Cyan color.
PaleOrange	The Pale Orange color.
PaleGray	The Pale Gray color.
Red	The Red color.
Yellow	The Yellow color.
Green	The Green color.
Blue	The Blue background color.
Purple	The Purple color.
Cyan	The Cyan background color.
Orange	The Orange color.
Gray	The Gray color.
GradientRed	The Red color used in gradient ranges.
GradientYellow	The Yellow color used in gradient ranges.
GradientGreen	The Green color used in gradient ranges.
GradientBlue	The Blue color used in gradient ranges.
GradientPurple	The Purple color used in gradient ranges.
GradientCyan	The Cyan color used in gradient ranges.
GradientOrange	The Orange color used in gradient ranges.
GradientTransparent	The transparent color used in gradient ranges.
FontBold	The bold font.
FontItalic	The Italic font.
FontUnderline	The underline font.
FontGrayed	The Gray font.
FontRed	The Red font.
FontYellow	The Yellow font.
FontGreen	The Green font.
FontBlue	The Blue font.

Related API Members

The following properties accept/return FormatConditionAppearanceType values:

• AppearanceSettings.AppearanceType
• ColorStyleSettings.PredefinedColor

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the FormatConditionAppearanceType enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-apply-conditional-formatting-to-grid-cells-in-win-dashboard/CS/Dashboard_ConditionalFormatting_Grid/BarConditionForm.cs#L14

FormatConditionBar barCondition = new FormatConditionBar();
barCondition.StyleSettings = new BarStyleSettings(FormatConditionAppearanceType.PaleBlue);
barCondition.NegativeStyleSettings = new BarStyleSettings(FormatConditionAppearanceType.PaleRed);

how-to-apply-conditional-formatting-to-grid-cells-using-the-value-format-condition-t259897/CS/Dashboard_ConditionalFormatting_Grid/Form1.cs#L17

lessThanCondition.StyleSettings =
    new AppearanceSettings(FormatConditionAppearanceType.FontRed);
lessThanRule.Condition = lessThanCondition;

how-to-apply-conditional-formatting-to-grid-cells-using-the-bar-format-condition-t304315/CS/Dashboard_ConditionalFormatting_Grid/Form1.cs#L15

FormatConditionBar barCondition = new FormatConditionBar();
barCondition.StyleSettings = new BarStyleSettings(FormatConditionAppearanceType.PaleBlue);
barCondition.NegativeStyleSettings = new BarStyleSettings(FormatConditionAppearanceType.PaleRed);

how-to-apply-conditional-formatting-to-grid-cells-using-the-date-occurring-format-condition-t267749/CS/Grid_DateOccurring/Form1.cs#L21

dateOccurringCondition.StyleSettings =
    new AppearanceSettings(FormatConditionAppearanceType.PaleOrange);
dateOccurringRule.Condition = dateOccurringCondition;

how-to-apply-conditional-formatting-to-pivot-cells-t267344/CS/Pivot_ConditionalFormatting/Form1.cs#L17

greaterThanCondition.StyleSettings =
    new AppearanceSettings(FormatConditionAppearanceType.Green);
firstLevelRule.Condition = greaterThanCondition;

VB.NET

how-to-apply-conditional-formatting-to-grid-cells-in-win-dashboard/VB/Dashboard_ConditionalFormatting_Grid/BarConditionForm.vb#L18

Dim barCondition As New FormatConditionBar()
barCondition.StyleSettings = New BarStyleSettings(FormatConditionAppearanceType.PaleBlue)
barCondition.NegativeStyleSettings = New BarStyleSettings(FormatConditionAppearanceType.PaleRed)

how-to-apply-conditional-formatting-to-grid-cells-using-the-value-format-condition-t259897/VB/Dashboard_ConditionalFormatting_Grid/Form1.vb#L19

lessThanCondition.Value1 = 100000
lessThanCondition.StyleSettings = New AppearanceSettings(FormatConditionAppearanceType.FontRed)
lessThanRule.Condition = lessThanCondition

how-to-apply-conditional-formatting-to-grid-cells-using-the-bar-format-condition-t304315/VB/Dashboard_ConditionalFormatting_Grid/Form1.vb#L18

Dim barCondition As New FormatConditionBar()
barCondition.StyleSettings = New BarStyleSettings(FormatConditionAppearanceType.PaleBlue)
barCondition.NegativeStyleSettings = New BarStyleSettings(FormatConditionAppearanceType.PaleRed)

how-to-apply-conditional-formatting-to-grid-cells-using-the-date-occurring-format-condition-t267749/VB/Grid_DateOccurring/Form1.vb#L22

dateOccurringCondition.DateType = FilterDateType.MonthAgo1 Or FilterDateType.MonthAgo2
dateOccurringCondition.StyleSettings = New AppearanceSettings(FormatConditionAppearanceType.PaleOrange)
dateOccurringRule.Condition = dateOccurringCondition

how-to-apply-conditional-formatting-to-pivot-cells-t267344/VB/Pivot_ConditionalFormatting/Form1.vb#L18

greaterThanCondition.Value1 = 30000
greaterThanCondition.StyleSettings = New AppearanceSettings(FormatConditionAppearanceType.Green)
firstLevelRule.Condition = greaterThanCondition