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 <[email protected]> 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: [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 -- To unsubscribe 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
