I think what you are asking for can't be done.
It might be worth asking on the devs list to see if they have some quick way of diving into the
code or it might be worth posting a bug-report about it as a "feature request". There might
already be a bug-report although i seem to remember the last person asking about this got his task
done some other way.
From: Tanstaafl <firstname.lastname@example.org>
Sent: Friday, 19 July 2013, 11:44
Subject: Re: [libreoffice-users] Cell references - apply formats too?
On 2013-07-18 10:52 PM, Brian Barker <email@example.com> wrote:
What you can do, of course, is to set up another column or row in which
you put suitable values which can then control conditional formatting of
both the target cell and the referencing one. To change the background
of both, you merely need to change the controlling values. These could
even be colour names: "red", "green", and so on.
Doesn't do what we need (see my last response to Errol), but thanks for
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy