Re: [libreoffice-users] conditional formatting broken?

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 <tomcloydmsma@gmail.com> 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
> * << tc@tomcloyd.com >> (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: 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

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