LibreOffice Calc: Is there a possibility to copy a background color from another cell?

Question

I have created a table that has a value on one column that I have used to generate a background colour (Format -> Conditional Formatting -> Color Scale... -> Colour Scale). Now I would like that all the row to have that colour. Is it possible to copy the background colour from another cell?

EDIT:

So this is my table:

And what I want is to colour all the cells from class group with the same colour as its total group.

Meaning that for the class 101 I want all the cells to have the same yellow-orange as the cell containing 592:

(this is done manually)

I want this to be some kind of formula, so any change in the last column is going to change all the colours. Is it possible?

Answer 1

Set the condition of each cell in a row to be the same as the condition you used for "total_group" cell in the same row. Meaning base the condition on the value of the "total_group" cell (Exact same condition no changes)