How can I assignate to a number Ã* color?

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

you can use a conditional format.

Under Format -- Conditional Format

set condition 1 for cell values = 1, then hit the Format button to set the
color of the cell under pattern.



"raffiki" wrote:

How can I assignate to a number Ã* color?

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

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