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?

As far as I know not.

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.
Maybe this will change someday in the future, but I haven't noticed any
request for it last time I checked. (Although I have to admit this was
sometime ago and I didn't try very hard.)

Thanks. I will hunt through the bugs database and file a feature request if I can't find anything.

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.

--
Sander Marechal
Product Developer
[EMAIL PROTECTED]

Tribal Internet Marketing &
Internet MARKeting van Werven
Larenweg 24
5234 KA 's-Hertogenbosch
The Netherlands

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to