If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Colouring cells automatically
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. |
#3
|
|||
|
|||
Colouring cells automatically
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 |
#4
|
|||
|
|||
Colouring cells automatically
Wicked response time thanks
|
#5
|
|||
|
|||
Colouring cells automatically
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 |
#6
|
|||
|
|||
Colouring cells automatically
Thanks Gord but what is VBA??
|
#7
|
|||
|
|||
Colouring cells automatically
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?? |
#8
|
|||
|
|||
Colouring cells automatically
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 |
Thread Tools | |
Display Modes | |
|
|