Search code examples
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:

    Result