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?