At 22:37 15/01/2015 -0700, Emil Payne wrote:
I'm a home user without a lot of spreadsheet experience.
I have a graph with several lines. I'd like line 1 set so that when
I enter a value in the box, that value would stay black if between
an upper and lower limit (e.g. 50-100) and to change to a red font
if outside that limit. Then line 2 would have a different set of
limits as would line 3. Is this possible to automate?
At 22:40 15/01/2015 -0700, Emil Payne wrote:
Sorry, I meant to insert an image. The red at the top is just a
reminder to me of what the limits are.
At 22:46 15/01/2015 -0700, Emil Payne wrote:
I might as well add the chart too. You can see the mean average of
the red graph at 184 (currently).
Your first image is of a range of cells but you start by referring to
a chart. If you are talking about setting the colour of lines on a
chart, I don't see any way to automate that.
But I'm guessing that you want the values you enter in cells (not
"boxes") to assume different text colours depending on their values.
o Select each range of cells to which you want this aspect to apply
and go to Format | Conditional Formatting... . "Color scale" will
give you background colours, but for text colours you probably need Condition.
o Set the required conditions for data values.
o Select cell styles appropriately - either from existing styles or
using the New Style facility to create them on the fly. Text colour
is selected on the Font Effects tab of the Cell Style dialogue.
Note that - as you require - you can set different conditions for
different ranges of data cells, reusing existing cell styles or
creating new ones as preferred.
I trust this helps.
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy