I want to apply a conditional format (colour scale) to cells in my spreadsheet.
In each row I want to highlight high/low/medium values - in the context of that row only, not all the rows with conditional formatting.
When I do this at first it works, like this. Each row has it’s own condition statement, like this
Conditional formating example - before.ods (16.3 KB)
But when I close the document and reopen it the condition applies across all the rows I have formatted. There is one condition statement applied to all the rows, like this