Set up a macro for Excel formatting
Posted on 1999-07-27
I need to be able to format some cells in Excel based on what number is typed in another cell. Here's my example:
If the number in Cell C3 is a 1, then I need it to shade cells Z9:AP9. I also need the macro to copy Z9:AP9 and Paste Special, Values only, into the same range, Z9:AP9. If Cell C3 is a 2, then I need it to shade cells Z11:AP11 and do the paste special thing. If Cell C3 is a 3, then I need it to shade cells Z13:AP13 and do the Paste Special thing. This goes on through #14 for Cell C3 and skips every other row in columns Z:AP, if that makes sense. I don't know Visual Basic, but Microsoft told me it wouldn't be that hard to do in VBA. So if anyone can give me some help, it would be greatly appreciated. THANKS.