This concerns color scale variant of conditional formatting.
You can have min, [middle], max.
And they can be formulas.
In those formulas, you can reference cells.
Those cell references appear to be absolute and not relative.
I looked at and understand the example at: https://help.libreoffice.org/latest/media/files/scalc/lo/conditionalformatting.ods
In that case, there is one fixed min, middle, max so it makes sense.
But what if you have 3 reference columns of min, middle, max, which vary by row, and in each row you want to apply the color scale to data?
| min | mid | max | data1 | data2 | data3 |
| 1 | 5 | 10 | 2 | 7 | 11 |
| 1 | 50 | 100 | 2 | 7 | 11 |
| 1 | 50 | 100 | 2 | 25 | 70 |
| 50 | 75 | 100 | 2 | 25 | 70 |
For this, the cell references in the formulas of the min, middle, max would have to be relative. Or at least row-relative.
to look like this:
Is there a way?
BTW there seems to be no reason to make these references absolute by default. M40 could be relative and $m$40 could be absolute, like usual. Most (all?) of the conditional formatting already works that way.
