Don I need help one more time

[desperate in MS]

That macro for inserting rows worked like a charm.

So many folks have tried to help and you get it on the first try. Your a god
send.

NOW....how can I highlight everyother row, including the ones as I insert
them?

 

[Bob Phillips]

I thought it was Greg who did?

 

[nwarnock]

That macro for inserting rows worked like a charm.

So many folks have tried to help and you get it on the first try. Your a god
send.

NOW....how can I highlight everyother row, including the ones as I insert
them?

There's a slick conditional formatting formula that accomplishes
that.

http://www.cpearson.com/excel/banding.htm