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

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