On 16/12/12 14:12, darwinev0lved wrote:
Hi there, hoping this is easy : I'm using a vlookup function to return some text from a cell. Is there a way to return not just the text but also the background colour of the cell? Or, thinking about it another way, if I just do A1=B1, this only makes the contents of the cell the same, is there some way to make the formatting the same ?
I immediately thought of something like 'Paste Special' but then realized that it could not be included in a formula. Perhaps there is some way to link just the formats of one cell to another?
Hih Hylton -- ======================================================================== Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A) http://e-clubhouse.org/sites/fishhoek/index.php being part of the worlds largest non profit NGO ======================================================================== -- For unsubscribe instructions e-mail to: [email protected] 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
