Ask Your Question

How do I reference a cell value and it's background color

asked 2019-05-17 05:57:17 +0200

heyehd gravatar image

updated 2020-07-21 12:28:01 +0200

Alex Kemp gravatar image

I have a cell "Master.B8" and would like to change both the value and the font color of a cell referencing "Master.B8" from another sheet "Panel1.B8". So if I change the font color on Master.B8 then Panel1.B8 will also change color.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-05-17 08:00:46 +0200

ebot gravatar image

updated 2019-05-17 09:14:11 +0200

In my opinion, the best solution is to use the same "Conditional Formatting" for each cell. I assume that both cells always contain the same value. A description for the "conditional formatting" can be found here.

If my answer did solve your problem, please click the big checkmark inside the circle to the left of this answer. It then indicates to the other participants that the question has been answered correctly.

edit flag offensive delete link more


With me Windows 10 Home; Version 1809; 64-Bit | LibreOffice, Version: (x64).

ebot gravatar imageebot ( 2019-05-17 09:13:44 +0200 )edit

answered 2019-05-17 22:34:02 +0200

heyehd gravatar image

Unfortunately Conditional Formatting only tests against values and not styles. Think of the Paste Special command and just paste the format, but in this case that functionality is associated with a =[ref]. So something like =Format(B8;Font_Color) or somesuch.

My only other possible option is to create a basic macro that tests the reference cell for font color then changes the current cell font color. Then make that macro a user function. So something like UserChangeFontColor(B8).

edit flag offensive delete link more


Sorry that my post did not help. But there are enough capable users you can tell you how your desire can be implemented.

ebot gravatar imageebot ( 2019-05-18 06:40:31 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-17 05:57:17 +0200

Seen: 230 times

Last updated: May 17 '19