EXCEL MACRO - fill column with color
 

guys...i need help in excel to fill the column color..

for example i need to fill the column with color red .. how to do it..

my purpose is that when i key in the word "r" or "R" then the colum
beside it will autofill color of RED

if target.column = 5 then

select case target.text

case "r" OR "R" ' this synta
correct?
****** here i need the syntax to fill the next
column with red color

case "y" or "Y"
****** yellow color in the next column

end select

else


exit sub

end if


pls help me..please..

--
Message posted from http://www.ExcelForum.com

EXCEL MACRO - fill column with color
 

Check out http://www.cpearson.com/excel/colors.htm
to set your colourindex



"tpk1031 " wrote in message
...
guys...i need help in excel to fill the column color..

for example i need to fill the column with color red .. how to do it..

my purpose is that when i key in the word "r" or "R" then the column
beside it will autofill color of RED

if target.column = 5 then

select case target.text

case "r" OR "R" ' this syntax
correct?
****** here i need the syntax to fill the next
column with red color

case "y" or "Y"
****** yellow color in the next column

end select

else


exit sub

end if


pls help me..please...


---
Message posted from http://www.ExcelForum.com/

EXCEL MACRO - fill column with color
 

Target.Interior.ColorIndex = ????


On Thu, 16 Sep 2004 23:39:24 -0500, tpk1031
wrote:

guys...i need help in excel to fill the column color..

for example i need to fill the column with color red .. how to do it..

my purpose is that when i key in the word "r" or "R" then the column
beside it will autofill color of RED

if target.column = 5 then

select case target.text

case "r" OR "R" ' this syntax
correct?
****** here i need the syntax to fill the next
column with red color

case "y" or "Y"
****** yellow color in the next column

end select

else


exit sub

end if


pls help me..please...


---
Message posted from http://www.ExcelForum.com/