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

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:
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.