.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

ConditionalFormatting.StopIfTrue Property

Specifies whether the rules with lower priority can be applied.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

bool StopIfTrue { get; set; }
Property StopIfTrue As Boolean
bool StopIfTrue { get; set; }
Property StopIfTrue As Boolean
bool StopIfTrue { get; set; }
Property StopIfTrue As Boolean

Property Value

Type Description
Boolean

true, if no conditional formatting rules with lower priority can be applied over the specified rule; otherwise, false.

Property Value

Type Description
Boolean

true, if no conditional formatting rules with lower priority can be applied over the specified rule; otherwise, false.

Property Value

Type Description
Boolean

true, if no conditional formatting rules with lower priority can be applied over the specified rule; otherwise, false.

Remarks

Use the StopIfTrue property to determine how to evaluate overlapping conditional formatting rules on a cell. For example, you have two rules: the "Top 5" rule sets the cell background color to light-green, while the "Greater Than 7000" rule changes the font color to blue-violet. As the "Greater Than" rule is specified after the "Top 5" rule, it is added to the beginning of the conditional formatting rule collection and has the highest priority, "1". By default, the StopIfTrue value of the "Greater Than" rule is false, so that all the cells that satisfy conditions of the first and second rule at the same time have the light-green background with the blue-violet font. However, if you turn on the StopIfTrue property for the "Greater Than" rule by setting it to true, only this rule will be applied to the cells that satisfy both conditional formatting criteria, while the "Top 5" rule will be ignored.

StopIfTrue = false StopIfTrue = true
SpreadsheetControl_ ConditionalFormatting_StopIfTrueFalse SpreadsheetControl_ ConditionalFormatting_StopIfTrueTrue

If the overlapping conditional formatting rules affect the same format attributes of the cell (for example, all of them specify the background color), only the format of the rule with the highest priority will be applied, despite the StopIfTrue value. By default, the last created rule has the highest priority (for more information about the rule precedence, refer to the ConditionalFormatting.Priority property).

Note that the StopIfTrue property does not take effect for the rules that format cells using data bars, color scale or icon sets.

See Also