Hi :) OOops, other Tom, sorry! Regards from Tom :) On 26 March 2014 11:48, Tom Davies <tomc...@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-libreoff...@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+unsubscr...@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+unsubscr...@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