Changing font colour

I want to be able to colour code a list of fixtures where each cell in a range shows either AWAY TO or HOME TO or NEUTRAL. I want AWAY to be red, HOME to be blue and NEUTRAL to be black. I have managed to create a macro to achieve this one column (out of 4) and one colour at a time, but being a novice I cannot work out how to do it in VBA so that I can do the whole job in one go.

It obviously can be done so any help or advice will be appreciated.

Peter Rump

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