Colouring cells automatically

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.

Use formatconditional formatting cellis if less than 4 conditions, else use
a worksheet_change event

--
Don Guillett
SalesAid Software

"Del" wrote in message
...
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.

Del wrote:
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

Wicked response time thanks

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

On Fri, 21 May 2004 13:05:47 -0500, gls858 wrote:

Del wrote:
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

Thanks Gord but what is VBA??

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Del" schrieb im Newsbeitrag
...
Thanks Gord but what is VBA??

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

On Sat, 22 May 2004 09:43:07 +0200, "Frank Kabel"
wrote:

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