libreofficelibreoffice-calc
libreoffice calc: background color of cell based on background of other cell
LibreOffice Version: 6.4.7.2
Build ID: 1:6.4.7-0ubuntu0.20.04.8
In libreoffice calc we can format styles: Menu -> Styles -> Menage Styles
Let's say I have formatted A1 cell so it is red when I type wordA into it, green when I type wordB when, yellow if wordC etc....
How do I force to change cell A2 to reflect same color as A1 ?
In other words: If I change manually value of A1 I want to have both cells changed regardless of value inside A2.
Is it possible?
Solution
Yes, it's possible
Just write the conditional formatting correctly for all your cases and apply it to the correct range of cells:
