Re: [libreoffice-users] conditional formatting broken?

At 12:57 25/03/2014 +0000, Tom Davies wrote:
> On 23 March 2014 14:22, Tom Cloyd wrote:
> > I'm using LO 4.2.1.1, on Kubuntu Linux 13.10
> >
> > I just noticed that a big spreadsheet which has a number cells with 
> > a background whose color depends on the value of integer in the 
> > cell is all wrong. I tried resetting - recreating - the conditional 
> > formatting. It just doesn't do anything.
> >
> > The number in the cell is calculated by a formula. I do have 
> > autocalculate turned on. Pressing F-9 does not affect the 
> > conditional formatting (just a while grab I tried).
>
> I thought it wasn't possible to set the background colour according 
> to a changing value within a cell.  I didn't think MS Excel can do 
> it either.  For advanced spreadsheeting-fu i would turn to Gnumeric 
> but i didn't think that could do it either!

On the contrary, it is certainly possible in Calc: a cell's 
background colour is a property of a cell style, and it's a cell 
style that is applied by conditional formatting.  Unsurprisingly, you 
can also do it in Excel.  As for Gnumeric ...

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