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