You can apply colors automatically to cells depending on its value.
This coloring will work with both conventional columns or calculations and it will work with numeric and text based grades.
The color configuration depends on the grade type assigned to a specific column.
Creating a grade type for our columnIn our example we will work with a column that holds a Quiz result with a score out of 60.
We will create a new grade type with our colors configuration.
Double tap on the header > Grade type > Edit > Add new > Number based grade
Our Quiz column will look like this