I’m creating a template in LibreOffice Calc. If the background color of a cell in a specific range of the first sheet is changed, I want the background color of the corresponding cell on the second sheet to update to the same color. I will be changing the first sheet manually, by using the format options. How should I set up my template to achieve this behavior?
I tried briefly with conditional formatting, but could not figure out how to set a conditional based on the cell’s background color. I am happy to try a macro-based solution if someone can give me a few pointers.