vba To Update A Column

[timbo1957]

This macro identifies specifc codes in column A and changes the colour of the cell accordingingly.

Can someone give me a macro that will run down column A starting at A6 and edit the cell and move on down to A160 so that all of the formats are correct?

Many thanks

Please Login or Register  to view this content.

[Richard Buttrey]

Have you considered using conditional formatting rather than VBA? It would be more efficient.

[timbo1957]

I'm using Office 2003 at work and that only allows three options for conditional formatting, or is there a cheat that I don't know about?