You can get up to 6 colors using this technique:

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

Otherwise, you'll need to use an event macro.

In article ,
kuroitenpi wrote:

I have been using MS Excel for years now, but my new job requires a little
more indepth knowledge which I really hope some of you can assist me with
cause I really don't want to have to ask the boss. Right now I am trying to
take a value from a cell and have it automatically color code the font, ex.
a1:a2:b1:b2 value of 0=red, 1-50=black, 51-100=blue etc. if any of you can
help me out I would greatly appreciate it.