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

On 02/07/2015 10:14 AM, 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
Dave,

I think you are looking for conditional formatting (FORMAT>>CONDITIONAL 
FORMATTING). Try it, you may need to modify your scenario to get the 
exact results you want. I have not used it recently.

--
Jay Lozier
jslozier@gmail.com


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