highlight columns A:M based on cell value

Hi all,

This is probably an easy one for you genii - but it has me frustrated.

I am working on a spreadsheet that will be used by Excel 2003 users. Each row in the data is given a letter code, A, D, R or I. Based upon this letter the corresponding row needs to be a specific colour. Due to the limited number of conditional formats in Excel 2003 I am using VB to achieve this affect:

Please Login or Register  to view this content.

This code works fine to highlight the whole row, but how do I adapt this to highlight only rows A:M?

Any help as always greatly appreciated,

SA

Right then,

I've had a play about and by combining your suggestions with my original script, this seems to work:

Please Login or Register  to view this content.

SA