allocate different colors to each number

[Juliana]

How do I assign a different color automatically to each numeric as I enter
them in an assigned field?

 

[t8pboy]

You could try "conditional formating" you can only create 3 conditions but
you control what the background or font color is in those cells.
here is a link that will explain it better than I can. Its easier than it
sounds
http://office.microsoft.com/en-us/assistance/HP011739141033.aspx

 

[Bob Phillips]

See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)