At 04:12 16/12/2012 -0800, Jon Noname 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 ?
There is no easy way that I see. I think you need to back-track to an earlier point in your problem. How do the source cells gain their background colours in the first place? They are presumably not random, even if they are imposed manually. If possible, devise a way of using conditional formatting to apply these colours originally. Note that the condition(s) can depend on other values than in the cells themselves, so you may wish or need to create additional data parallel to your source data which will govern the background colours of the source cells themselves. (This parallel data can conveniently be elsewhere or hidden if preferred, of course.) Alternatively, just include additional data that defines how you have chosen to select the background colours.
Once you have done this, it should be a simple matter to apply conditional formatting - probably depending on the original source cells, not the target cells - to your harvested values in the target cells.
I trust this helps. Brian Barker -- 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
