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:
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:
(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
No one has answered this question yet
Check out similar questions: