Applying sets of conditional formatting rules

asked 2020-03-25 22:08:40 +0100

zf gravatar image

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.

edit retag flag offensive close merge delete


Opaque gravatar imageOpaque ( 2020-03-25 23:07:48 +0100 )edit

@Opaque Thanks for the answer to the other questions,-- played for conditional formatting a bit after and was able to get it mostly to how I want it. I think my question on this thread is different though, here's an example:

I want alternate background row color (in blue) as a general rule that applies to the entire spreadsheet. I want another rule that colors a cell in one column (in red) if another cell on another column has the text "denied" if it it's in the same row. The latter rule should take precedence over the former, i.e. a cell that should be blue is colored red if both conditions are met.

It seems I am not able to set precedence of the two rules because they do not apply to the same set of cells--one applies to all spreadsheets and one applies to only cells ...(more)

zf gravatar imagezf ( 2020-03-28 17:26:51 +0100 )edit