How many numbers?

If not more than 4 you can use conditional formatting.

Otherwise you will need VBA code, an add-in from Bob Phillips or Excel 2007

Bob's CFPlus add-in can be found here.

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


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 06:12:02 -0700, raffiki
wrote:

How can I assignate to a number à color?

Exemple 1=green; 2=red; 3= bleu