Filling alternating rows in a worksheet with color backgroud

  • Thread starter Thread starter Tom L
  • Start date Start date
T

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!
 
Back
Top