ConditionalFormatting.StopIfTrue Property
Specifies whether the rules with lower priority can be applied.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v23.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
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 |
|---|---|
 |
 |
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.