allocate different colors to each number
 

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

allocate different colors to each number
 

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/as...739141033.aspx

allocate different colors to each number
 

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

--
HTH

Bob Phillips

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

"Juliana" wrote in message
...
How do I assign a different color automatically to each numeric as I enter
them in an assigned field?