Hi there, I need to colorize the cells of a column based on the value with a range.
For example, I have the numbers from 0 to 10.
What I need to do is to make 1~3 to be green, 8~10 to be red, and the rest of cells stay in no background color.
According to the supported conditions, we are not able to give it a range such as 1 <= value <= 3.
It only support <, >, <=, >=, =, and !=.
If the metabase could support white color(no color), we can use this to design whatever we want.
I think this idea would be much easier than apply a new function.
thanks
Joey