Re: [libreoffice-users] conditional formatting broken?

Hi :)
OOops, other Tom, sorry!
Regards from
Tom :)

On 26 March 2014 11:48, Tom Davies <tomcecf@gmail.com> wrote:
> Hi :)
> Ahh, i cheat.
>
> 1.  Select the cell, row, column, area or even entire worksheet.
> 2.  Format - Cells - Number (the 1st tab in the pop-up)
> 3.  In "Category" down the left-hand side, click on "Number"
> 4.  tick the box that says "Negative numbers red"
>
> Regards from
> Tom :)
>
>
> On 26 March 2014 07:56, Alex McMurchy
> <mcmurchy1917-libreoffice@yahoo.co.uk> wrote:
> > Tom
> >
> > Perhaps a bit more detail would be useful can you give us the steps that you are following.
> >
> > The steps below would change the font colour of all selected cells that contains the number 0 to 
> > the same as the white background, i.e. they become invisible.
> >
> >      *  Select cells to conditionally format
> >      *  Format -> Conditonal Formatting -> Condition
> >
> > Conditional Formatting dialog appears
> >      *  Change condition 1 to [Cell Value is] [Equal to] [0]
> >      *  Appply style [New Style]
> >
> > Cell Style dialogue appears
> >      *  Click on Font Effects Tab
> >      *  In [Font Colour] drop down menu selected white
> >      *  Push the [OK] button
> > Returns to Conditional Formatting dialog
> >      *  Push the [OK] button
> > Returns to the sheet with selected cells formatted
> >
> > Alex
> >
> >
> > On Sunday 23 Mar 2014 08:22:37 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).
> > >
> > > Any ideas about what's wrong? Is this a known bug for this version?
> > >
> > > t.
> >
> > --
> > 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