View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ibbuggin Ibbuggin is offline
external usenet poster
 
Posts: 5
Default how do i lock in highlights for every other row in excel

I have a spreadsheet and I have highlighted every other row. When I delete
or add a row, the highlighting sequence becomes messed up. I then have to go
back and manually highlight every other row. Is there a way to format the
spreadsheet so that when I add or delete a row, the spreadsheet automatically
keeps the "every other row highlighted" sequence in effect?