Formatting Macro

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!

Originally Posted by JBeaucaire

No need for a macro if this is all you're trying to do. This is what conditional formatting is for. If the ODD/EVEN cells were in column A:

1) Highlight all the columns you want to behave this way
2) Click on Format > Conditional Formatting
3) Condition1 > Formula Is: =A1="ODD"
4) Select Format... Patterns tab: color of choice

I may have Excel record those actions into a macro for me. The sheet I'm creating is for my employees and I want to make it as painless as possible for them whenever they make a change that requires reformatting line colors.

Thanks! This information will get the job done!