Author should be able to select multiple columns for one conditional formatting rule.

Rajakumar Burra

Author should be able to select multiple columns for one conditional formatting rule.

Sometimes we need to highlight multiple columns for same rule. Currently we are able to select only one column for one rule.

Workaround is creating multiple rules by copy paste but it has below limitations.

• Legend displays multiple times for each rule. It confuses the users and takes space for duplicate rows.
• Managing multiple rules is difficult. It is prone to user errors.