Cell style can change based on conditional rules. Conditional rules are written as formulas. Conditional formatting applies to the entire column. To add conditional formatting to a particular column, go to the
Cell Style section of the creator panel and click on
Add conditional style.
In this example, we have a list of dog breeders who have raised champion thoroughbreds. Let’s apply conditional formatting to the Breeder column based on the number of champion dogs. We would like to highlight in gold any breeders with more than 2 champions.
Here the conditional formula is
$Number_of_Champions > 2.
We would also like to highlight breeders with 1 or 2 champion dogs in blue, and 0 champion dogs in brown. Click
Add another rule to add more conditional styles.
Order of Rules#
Note that Grist applies the rules in order. Styles applied by later rules will override those applied by earlier rules.
What would happen if we swapped the last two rules?
Notice that Gen Hamamoto, who has 0 champion dogs, is not highlighted in brown. This is because after applying the second conditional style,
$Number_of_Champions == 0, Grist applied the third,
$Number_of_Champions <= 2, which applies to Gen Hamamoto as well and shades him blue.