Some questions about using conditional formatting:
I would like to apply different sets of conditional formatting rules. For example, a
set of rules named “my-general-style” for general styling) like alternating row colors that I want
applied always and every where. Then another set of rules named “my-warning-style” that represent certain
data in cells as “warning” (e.g. fill background color of cells whose values
are greater than ‘80’).
Is it possible to toggle “my-warning-style” on/off (i.e. enabled/disabled) while
keeping “my-general-style” on?
If I want the general rule for alternating row colors to take lower
precedence than the rule for values > 80, then I would need to group them in
the same set of rules. I only see the option to set the precedence of rules
within a set of rules–there is no option to move up/down rules in “managing
conditional formatting” window.
Is it possible to name a set of conditional formatting rules? I don’t see that option available but it seems like it would be desirable.