Banding rows in an Excel Table

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

3 thoughts on “Banding rows in an Excel Table”

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
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.
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.