Hello!
I would like your help to solve the following problem:
We conducted a survey where people answered questions and received points. Now we need to filter the score value by color
There are 3 colors for cells, which are colored when the following conditions match:
Red: if a person scored a low number of points in 4 categories
Yellow: if there are no red blocks out of 4 and less than 3 green blocks
Green: There are no red blocks, more than two blocks are green out of 4
Points: red if scored from 0 to 11 points in each category
yellow if from 11 to 17 points
green if from 17 to 25 points
How can automation be assembled so that colors are assigned automatically based on these formulas? Conditions in coloring are not suitable, since it only looks at 1 condition\
Thank you very much in advance for your help
