3 thoughts on “Banding rows in an Excel Table

  1. Thanks.

    The article was getting too long. So, I decided to split the conditional formatting approach to bands into a separate post. Hopefully, soon. {grin}

    I checked out your posts. Nice and concise summary of table features.

  2. The VBA code to introduce a zebra-format to a sheet:

    Range(Join(Filter([transpose(if(mod(row(1:100),2)=0,“A” & row(1:100),“”))], “A”), “,”)).EntireRow.Interior.ColorIndex = 16

    It also bears in it every form of conditial formatting.


Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published. Required fields are marked *