Up to three colors you can use Conditional Cell Formatting, which
overrides your normal cell formatting.
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Beyond 3 colors for a cell, you would normally use an Event macro
http://www.mvps.org/dmcritchie/excel/event.htm

but you could use an addin that works like C.F. and is extended:
Extended Conditional Formatter «Excel addin«, Bob Phillips & Frank Kabel,
addin that makes it possible to enter up to 50 conditions
works the same as C.F.
http://www.xldynamic.com/source/xld.....Download.html

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"bob sacco" wrote in message ...
I'm in need of using the same number format formula you suggested earlier for
a guy who wanted to color text in a cell within a range...for example he
wanted to color something red for everything over 10% and also color thing
YELLOW that were between 8% and 10%. THe formula you used went something like
:
[Red][0.1]0%;[Yellow][0.08]0%;0%;@

What I want to do is color THREE numbers in a range.

I want to color .1 (green) and then .5 (blue) and then .9 (RED) and finally
0 (black)

How do I do this using a modified number format like the one described above?