Filling alternating rows in a worksheet with color backgroud

[Tom L]

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!

 

[John Wilson]

Tom,

Conditional formatting should do it.
Take a look here:

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

John