Text Decoration in Higher-Priority Conditional Formatting Rules

Renny

Current state example: Two conditional formatting rules. The lower-priority one sets font weight to bold. The higher-priority one sets font weight to normal (not bold). The result, in a row that triggers both rules, is that the font weight remains bold. It is not overridden by the higher-priority rule.

Desired state: The higher-priority rule overrides text decoration in the same way it overrides background color and font color. But even the colors have a defective implementation. When selecting Automatic color in a higher-priority rule, the behavior is to ignore and not to override the existing conditional formatting.

The choices should include something like: take no action, override with a style, override with automatic (and therefore negate styles set in lower-priority rules and apply automatic style).

thank you