Coloring the cell in the desired color when the conditions are met

[flavich]

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

[TheTimeSavingCo · Accepted solution]

I think you're going to need a formula field that calculates the number of each color there are for that record:

And you could then use those formula fields in your color conditioning

Link to base