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.
Color configuration does not exist for numeric generic grades, find below how to convert a generic grade (Total points 145) to a numeric grade.
We can assign colors to a text or numeric grade
In our example we will work with the column that holds a Quiz result with a score out of 145.
We will edit the grade type and assign our colors configuration.
Double tap on the header > Grade type > Edit
In our example, the max score is 145 min. 0. Tap now on colors and assign the colors you'd like for each value.
Here is how to proceed with detail
The cells in our example after our configuration.