You can apply colors automatically to cells depending on their values.
This coloring will work with both conventional columns and calculations and it will work with numeric and text-based grades.
The color configuration depends on the grade type assigned to a specific column.
Color configuration does not exist for numeric generic grades, find below how to convert a generic grade (Total points 145) to a numeric grade.
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 colour settings.
Double-tap on the header > Grade type > Edit
In our example, the max score is 145 minimum 0. Tap now on colors and assign the colors you'd like for each value.
The animation below shows the steps
The cells in our example after our configuration.
