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: [email protected]
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
