Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Number Format / Color and Sign
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Number Format / Color and Sign
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Number Format / Color and Sign
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving custom number format to NUMBER | Setting up and Configuration of Excel | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
color coding custom number formats | Excel Discussion (Misc queries) | |||
color coding custom number formats | Excel Discussion (Misc queries) |