How to automatically update the backgound color of a cell, based on the the background color of a cell in a different sheet?

asked 2017-02-19 13:32:51 +0200

cheflo gravatar image

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.

edit retag flag offensive close merge delete