There is a method here using custom formatting

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

otherwise you would need an event macro or an add-in

for the latter see:

http://www.xldynamic.com/source/xld.....Download.html

--
Regards,

Peo Sjoblom

(No private emails please)


"Allie" wrote in message
...
I would like to set up a spead sheet that when I enter specific numbers,
the
numbers will automaticly be in a pre-selected colors. I used conditional
formating, but it only allows three numbers, I need several