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 ? Thanks, Jon. -- View this message in context: http://nabble.documentfoundation.org/copying-formats-in-Calc-tp4024631.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@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