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

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