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?

 

[JE McGimpsey]

Couple of reasons:

- Custom formats can only have 3 numeric format fields, not 4.

- your [Blue] format doesn't have a numeric format.

- if you have numeric ranges in your custom format, the ranges must
encompass all numbers. In your format string, the format of any value
<0.01 is undefined.

- the syntax for greater than or equal to is ">=" rather than "=>"

See

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