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