Werner,

You need to use a combination of formatting (to set the number format) and conditional formatting
(to set the colors)

Select the cells and apply a custom number format of

+0%;-0%;0%

Then use conditional formatting, and set value is less than or equal to 0.05 to be red, value is
between 0.05 and 0.1 to be brown, and greater than or equal to .1 to be blue.

HTH,
Bernie
MS Excel MVP


"Werner Rohrmoser" wrote in message
...
Hello,

for Excel XP SP3 on WIN XP SP1

What I'd like to have is:
values above 10% = +NN% in blue
values between 5% and 10 % = + N% in brown
values between 0% and 5 % = + N% in red
values below 0% = - N% in red

My problem is to get the colors and the signs as described.
May be it's not possible.

Regards
Werner