Hi :) I thought it wasn't possible to set the back-ground 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!
The closest i got was making negative numbers red and that works about the same in all 3 programs. So, i hope someone else can help with this! Regards from Tom :) On 23 March 2014 14:22, Tom Cloyd <[email protected]> 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). > > Any ideas about what's wrong? Is this a known bug for this version? > > t. > > -- > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Tom Cloyd, MS MA (LMHC, WA State) > Cedar City / St. George, UT, U.S.A: (435) 272-3332 > * << [email protected] >> (email) << TomCloyd.com >> (website) > * Sleight of Mind blog: Sleightmind.com (mental health issues) > * Trauma Psych blog: http://thetraumapsych.wordpress.com > * Trauma! A PTSD blog: http://www.healthyplace.com/blogs/traumaptsdblog/ > * Founder: Google+ Trauma and Dissociation Education and Advocacy community > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > -- > 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 > -- 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
