Rules are processed from top to bottom as displayed on the settings page; the first rule found to be true is used. If there are no rules, or if none are true, then the default value is used (if one is provided).
In the below example, the rules have been automatically created. One of the rules has then been changed to “is not equal to”:
If the status is Completed, the first rule that is true is “is not equal to In Progress”, and so the remaining rules are ignored, displaying the yellow flag. If we change the order of the rules as follows, the status Completed will show a green flag:
If none of these rules are true, for example when the Status is In Progress, then the default icon selected in the Display section is used:
There is no problem with having more than one Highlighter column displayed on a list view, but in the case of Row highlighting there can be some overlap in what they’re trying to achieve. If more than one Highlighter column tries to set a row’s color, then they can overwrite each other.
Essentially this means that the color set by the rightmost Highlighter column (the one shown last) will be the color displayed.
As you would expect, rule precedence in for Advanced rules is slightly more complex. Highlighter checks the rules in exactly the same way as in Normal mode (top to bottom), but only looks at one action type at a time. So when Highlighter is determining the row color, it looks only at rules that change the row color, and picks the first that is true.
The only exception to this is the displayed value, as it can be changed by three action types: Display Column, Display Value, and Icon. In this case, Highlighter looks at all three types of rule at once, and uses the first true one.