LibreOffice Calc: is it possible to copy the background color from another cell?

I created a table that has a value in one column, which I used to generate the background color ( Format -> Conditional Formatting -> Color Scale... -> Colour Scale

). Now I would like the whole line to have this color. Can I copy the background color from another cell?

EDIT:

So this is my table:

enter image description here

And I want to color all the cells from the class group with the same color as its general group.

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

enter image description here (this is done manually)

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

+3


source to share





All Articles