«
»

Banding rows in an Excel Table

April 4, 2011, 5:11 pm by Tushar Mehta

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/0120-1%20banded%20rows.shtml

Tushar Mehta

Category: Uncategorized  |  Comment (RSS)  |  Trackback

3 Comments

  1. Jan Karel Pieterse says:
    April 6, 2011 at 4:25 am

    Nice post Tushar. Pity you end with a cliff hanger :-)
    I wrote a bit on tables myself some time ago:

    http://www.jkp-ads.com/articles/excel2007tables.asp
    and
    http://www.jkp-ads.com/articles/Excel2007TablesVBA.asp

  2. Tushar Mehta says:
    April 7, 2011 at 12:05 am

    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.

  3. hans schraven says:
    April 7, 2011 at 7:54 am

    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.

Leave a Reply