u dont really need a macro unless u really want one but u can achieve this without..

u cud use conditional formating on say cells A1:D10 but if u did it as a macro then i guess when ur selecting the colum 2 check u doing somethin like:

range("a1:a10").select

so u cud just make it

range("a1:d10").select

if not giv me an example and i will be able 2 c what 2 do but from what u said i wud change what i put above