Re: [libreoffice-users] Is This Possible In Calc?

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