Hi, I have a table with 27 columns and need that each column have a Conditional Formatting with 3 different colors:
Green => score above 3.5
Yellow => score from 2.5 to 3.5
Red => score under 2.5
Conditional Formatting in a table has a limit to 20 rules… and I need 81 rules (27 columns * 3 rules).
How I can make this work?
Thanks in advance
There is an open feature request for this: https://issuetracker.google.com/issues/160905477
I know that if you pivot by a dimension, you can get several columns from a single metric, and they will all listen to the same conditional formatting rule. That’s the closest I can think of a workaround.
Hi,
Since your formatted table should only have the three specified colours, you can achieve this easily, even with more columns.
Instead of applying conditional formatting to each column individually, try using the “Any selected field” option under the Conditional Formatting tab. You’ll find it at the bottom of the dropdown under Format Rules. This way, the formatting will be applied to any column that meets the condition, no matter which one it is.
Here’s the expected output:
https://lookerstudio.google.com/reporting/8a6add46-ea52-405d-badf-f104f2e92ea3
Really Thanks! 