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