color coding custom number formats

[bob sacco]

I'm attempting to color code a series of numbers using the custom number
format in the FORMAT MENU.

I need to color code four numbers (or ranges of numbers)

10%, 50%, 90% and 100%

Currently I have:
[Yellow][=>0.01] 0%;[Green][=>0.05]0%;[Blue][=>0.09];[Red][=>1]0%;@

But I can't get it to work.

Any ideas why?

 

[Dave Peterson]

J.E. McGimpsey shows how to get up to 6 different colors using a combination of
custom formats and conditional formatting at:

I'm attempting to color code a series of numbers using the custom number
format in the FORMAT MENU.

I need to color code four numbers (or ranges of numbers)

10%, 50%, 90% and 100%

Currently I have:
[Yellow][=>0.01] 0%;[Green][=>0.05]0%;[Blue][=>0.09];[Red][=>1]0%;@

But I can't get it to work.

Any ideas why?

 

[Dave Peterson]

oops. I hit send too fast.


J.E. McGimpsey shows how to get up to 6 different colors using a combination of
custom formats and conditional formatting at:

http://mcgimpsey.com/excel/conditional6.html

And watch out...

10% = .10
50% = .50
90% = .90
100% = 1

I'm attempting to color code a series of numbers using the custom number
format in the FORMAT MENU.

I need to color code four numbers (or ranges of numbers)

10%, 50%, 90% and 100%

Currently I have:
[Yellow][=>0.01] 0%;[Green][=>0.05]0%;[Blue][=>0.09];[Red][=>1]0%;@

But I can't get it to work.

Any ideas why?