This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Here's the formatting rules according to the documentation:
Using rules effectively requires understanding which rules comes first, and which ones override other ones. When two rules intend to change different styles (one changing a font, and the other changing the font size, for example), it doesn't matter which one executes first. But when two rules both intend to change the same style, only one them will win. Rules are executed in the following order, with later rules overriding earlier rules.
Default Table Settings have the lowest priority.
Row rule with only basic (non-formula) styles
Column rule with only basic styles
Row rule with only basic styles with the override checkbox selected
Row rule with formula styles
Column rule with formula styles
Row rule with formula styles with the override checkbox selected
Here is another way to look at this.
Formula styles always take precedence over non-formula (basic) styles.
Column rules usually take precedence over row rules, unless the row rule explicitly has its "override column rules" checkbox checked.
Rules take precedence over the per-column and default table settings.
Multiple rules of a given type (row or column, basic or formula) execute in the order they are listed in the rule editor.
Thanks @CharlieS, I cheated a bit by defining the rules for Column A, then deselecting all the other fields in the select tool and ran the workflow.
I then defined column rules for "dynamic and unknown fields", selected all the columns again and ran the workflow again which copied the rules to all the fields except column A, so I could then just edit the rule for the colour of the 1st 3 rows for fields F-J.