Assigning colors to grades automatically

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 column

In 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

In our example, the max score will be 60, min. 0. Tap now on colors and assign the colors you'd like for each value

Our Quiz column will look like this

Applying your colors to text or background