Given the following sheet in numbers:
I would like to highlight the maximum value for each column in green, and the minimum value of each column in red. I thought this can be done with conditional formatting. However, it seems not possible to use formulas, so I intruduced a new row at the top, which holds the max value of each column.
Now I can add conditional formatting, like so:
However, the problem is, that this only sets the correct conditional formattign for cell F3. For the remaining cells of the column, the conditional formatting auto-advances the referenced cell in the condition, e.g. :
This means I would need to adjust the formula in every cell, thus beeing the same effort as just coloring the cells myself, without conditional formatting.
So the question is: how can I easily hightlight the min/max values of a column as described above, without the need to do this manually for every cell?
Maybe as side note, I will enter new entries row by row, but once entered, those values will never change.