Here's what I want to do...

I have a column of cells:

ODD
EVEN
ODD
EVEN
ODD
EVEN

etc...

I'm trying to create a macro that will test each cell in this colum...if the cell equals 'ODD' it will turn a range of cells in the same row a different color. It will do nothing if the cell doesn't equal 'ODD'.

Been having a devil of a time trying to get a FOR loop going, and any IF statement I come up with just isn't cutting it for anything more than one row.

Thanks is advance!