- against another colum
- against the column's average or median
- average,median or a constant value.
Enable it first from the Settings (Main menu, Settings) > Cell editors, calculations
Comparing two columns (e.g. target vs grade)
We will begin with this example shown below. Our target grade on the first column and the obtained result (Exam 1) next to it. You can use any of the configured grade types for each column, they do not necessarily have to match.
This will be its configuration
And the result