[SOLVED] Coloring Percentage Values

madmike2010 · #1 10-07-2008, 08:48 PM

I need some help coloring percentage values in excel 2000. What I would like to do is have percentages greater than zero shown in green, while negative values are red, and zero values are black. I currently have the custom formatting so negative values are red and all others are black, but I cant' seem to find a way to change it so greater than zero numbers are green and zeros are black. All I can do is chang positive and zero at the same time. Here is what I currently have:

Code:

0.00%;[Red]0.00%

Any help would be appreciated,
Mike

mdbct · #2 10-07-2008, 10:43 PM

The custom formatting would be:

Code:

[Green]0.00%;[Red]-0.00%;0.00%

For custom formatting of numbers / percentages / currency the field is broken down as:

Positive value format ; negative value format ; zero value format

Cheeky Charlie · #3 10-08-2008, 06:17 AM

From help:

You can specify up to four sections of format codes. The format codes, separated by semicolons, define the formats for positive numbers, negative numbers, zero values, and text, in that order. If you specify only two sections, the first is used for positive numbers and zeros, and the second is used for negative numbers. If you specify only one section, it is used for all numbers. If you skip a section, include the ending semicolon for that section.

madmike2010 · #4 10-09-2008, 01:03 AM

Thanks for the help.
Mike

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Userform's listbox values depending on values on certain matrix	Juhanen II	Excel Programming	11	08-19-2008 09:01 AM
calculate cells between two values, and obtain the percentage	caldera55	Excel Worksheet Functions	1	05-15-2008 07:23 PM
creating a percentage chart based on values	dan_77	Excel Charting	1	02-27-2008 10:28 PM
Import and export a text document	Odysseus	Excel General	0	01-10-2008 10:41 AM
Adding Row Values depending on Corresponding Rows	chr5648	Excel Programming	3	06-13-2007 06:26 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)