Shade cells by cell value

[ecraw]

I don't have much experience with macros and could use some help. I have a spreadsheet with columns M thru AI to be shaded gray, except the first number of cells determined by the value in column L. So if L3=3, then M3,N3, and O3 should have no formatting, and P3 thru AI3 should be gray. Thanks in advance

[6StringJazzer]

This is best done with conditional formatting. I am using 2013 and converting to 2003 so hopefully what I've done here will work for you. You need to specify what you want when the value in column L is ALL or REF.

[stnkynts]

Have you tried Conditional Formatting? If you want a VBA way to do it try this:

Please Login or Register  to view this content.

[RudiS]

Try this code...

Please Login or Register  to view this content.

[ecraw]

Thanks to all who applied. If it's all or Ref I don't need any formatting either. The other concern with this is I thought in 2003 I am limited to how many conditional format rules I can use in a cell. If not,then this is perfect. Also, other PC's have different versions of excel, and it will need to work for all versions.