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


Hi :)
I like it when a few different people all give basically the same
answer but say it in different ways and with different levels of
detail.  It gives more confidence in the answer.  Different people
respond better to different styles of answer.

I vaguely remember this question being asked about 4 years ago and
getting no useful answer.  So i feel that this mailing list is working
well.  My main reason for joining the list was to learn without
spending time struggling through documentation as i tend to have
trouble concentrating for long enough.  The threads here show me the
fashionable or popular things that people try to do and help me
if/when i need to do those things.  Hopefully that helps me help my
colleagues more easily.

Many thanks for all these answers.  I hope they are helping the o.p. too! ;)
Regards from
Tom :)



On 7 February 2015 at 16:04, Kolbjørn Stuestøl <kolbjoern@stuestoel.no> wrote:
Den 07.02.2015 16:14, Dave Barton skreiv:

I don't believe the following is possible, but I hope some Calc guru
(Brian?) here can prove me wrong.

To have a formula in cell A which evaluates the contents of cell B and
changes the style, but NOT the content, of cell C.
eg. A1=contains the formula, B1=0, C1=20
Pseudo Code for cell A1: =IF(B1=10;C1=STYLE(whatever);"")
Changing B1 from 0 to 10 would result in the content of C1 still being
20 with the "whatever" style.


Use conditional formatting.
While in A1, or better in B1 or C1 I think, select *Format -> Conditional
Formatting -> **Condition*.
In the dialog window select "Formula is" in the drop down list. In the text
field write $B1=10
In the range field write C1.
In the drop down list (Apply Style) select a suitable style, or select New
Style to create a new style.
Press OK and all is done.
Kolbjoern





Any thoughts or pointers would be welcome.

Regards
Dave





--
To unsubscribe e-mail to: users+unsubscribe@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

-- 
To unsubscribe e-mail to: users+unsubscribe@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

Context


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.