Colouring cells automatically

[Del]

Is there a way of making a cell change colour automatically when I type a
certain number in i.e. 1 = red, 2 = green, etc.etc.

 

[Don Guillett]

Use format>conditional formatting cellis if less than 4 conditions, else use
a worksheet_change event

 

[gls858]

Is there a way of making a cell change colour automatically when I type a
certain number in i.e. 1 = red, 2 = green, etc.etc.

You want conditional formatting. Under Format click
conditional formatting. It's pretty simple from there.
If you need more help post back.

gls858

 

[Del]

Wicked response time thanks

 

[Gord Dibben]

Del

Note only 3 options(4 if you count default) in CF.

If you need more, VBA is required.

etc.etc leads me to believe you need more.

Gord Dibben Excel MVP

 

[Del]

Thanks Gord but what is VBA??

 

[Frank Kabel]

Hi
VBA: Visual Basic for Application
Microsofts programming languange for it's Office applications (also
called macros). See:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Gord Dibben]

Del

After absorbing some of the material at David's getting started site, check
out also his pages on Event macros.

http://www.mvps.org/dmcritchie/excel/event.htm

You would most likely use Worksheet_Change code for your purposes. David has
several examples of changing color depending upon value in a cell or cells.

Gord