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: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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