EXCEL MACRO - fill column with color

[tpk1031]

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..

 

[David Adamson]

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

 

[Myrna Larson]

Target.Interior.ColorIndex = ????