On September 3, 2007, Sander Marechal wrote: > J.A. de Vries wrote: > > On 2007-08-28 @ 16:53:22 (week 35) Sander Marechal wrote: > >> Is there a way to define new colors, or use RBG syntax in the > >> number-format to get a darker green? <snip> > > To my knowledge only CYAN, GREEN, BLACK, BLUE, MAGENTA, RED, WHITE and > > YELLOW are accepted as color names. You can define custom colors in the > > color picker, but they cannot be referenced in conditional formats. <snip> > In the mean time, I did find a workaround. I simply made the text in the > cells dark green, the used this for a number format: > > [<-0.1][RED]0%;[>0.1]0%;[BLACK]0% > > Without a color definition for the >0.1 case, it will use the default. > In this case, dark green.
I'm jumping into this thread late so forgive me if this has already been suggested. Another workaround for this may be to define cell styles for each case via F11 or "Format" -> "Styles and Formatting". Cell styles allow you to define text colour and/or background colour using the full range of colours and custom colours your installation of OpenOffice.org has. Apply your cell styles through "Format" -> "Conditional Formatting" instead of formatting numbers through the "Numbers" tab of "Format Cells". IanS --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
