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

On 7-2-2015 16:14, Dave Barton wrote:
> 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.
>
> Any thoughts or pointers would be welcome.
>
> Regards
> Dave

Format / Conditional formatting.....

This can put a 'conditional format' on cell C depending on a formula.....



--
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