Re: [libreoffice-users] Font color based on value

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