Hi!
Is there a way to crate a format rule with IF or IFS conditions?
I need to create several format conditions like the example for 20 columns and I´m trying not to create a single format condition for each IF.
Eg: IF(
OR([Status]<= 8,
[Status]>=8.1), “Green”,
“Red”
)
As far as I know, it’s not possible.
you can set only one condition per rule, i.e one condition for the green, and another one for the red.
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |