Well, I posted my e-mail before the other answers showed up.
But I agree with you, Tom.
This is *the* link if you needs help or some tips using LibreOffice.
Kolbjoern
Den 07.02.2015 17:23, Tom Davies skreiv:
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 <[email protected]> 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: [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
--
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
