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.
For unsubscribe instructions e-mail to: email@example.com
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
Impressum (Legal Info)
: 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