Custom Number Format / Color and Sign

[Werner Rohrmoser]

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

 

[Bernie Deitrick]

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]

Bernie,

yes, this works on the spreadsheet.

The next challenge is to transfer this formatting to the value labels
of a chart series.
It seems that only the number format is transferred to the chart
labels and
the conditional formatting is not.
I'm afraid that there is no solution only using the number format.

Regards
Werner