Tom,

Conditional formatting should do it.
Take a look he

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

John

"Tom L" wrote in message
om...
I want to insert code that will automatically fill all even numbered
rows with a background color. Adding to the complexity is the fact
that I will sometimes need to insert and delete rows and sort data as
I work with the data contained in the worksheet. My goal is that no
matter what I choose to do while working with the worksheet, I always
want the even numbered rows to be properly filled with a color of my
choosing.

Any help is greatly appreciated!