Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

Thanks! For others, I've screen captured one set of conditions to show what I did. I had to set the lower limit to include ABOVE 1 so that empty cells wouldn't turn red. I also set a style for normal entries to ensure they didn't change color somehow.

On 16/01/15 01:12 AM, Brian Barker wrote:
At 22:37 15/01/2015 -0700, Emil Payne wrote:
I'm a home user without a lot of spreadsheet experience.

No worries!

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. That's possible.

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.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.