View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom L[_2_] Tom L[_2_] is offline
external usenet poster
 
Posts: 1
Default Filling alternating rows in a worksheet with color backgroud

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!