Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

At 10:53 18/07/2013 -0400, Charles Marcus wrote:
Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also have a red background?

If you mean so that you can arbitrarily change the background of the target cell and the background of the referencing cell will follow suit, I think not: there appears to be no way to test the formatting of a cell or to retrieve the formatting details. At least, you can retrieve numeric formatting using the CELL() function, but not other aspects of formatting, including background colour. Unless someone knows better.

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.

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.