Excel – Format table with Zebra Stripes

November 11, 2007 at 5:40 am 10 comments

This type of formatting of table is easily possible with Excel 2007, but before that it was a pain.

Let’s see how we can use conditional formatting to our advantage in this area.

‘Zebra Stripes’ is basically coloring your table’s each alternate row, this will increase the readability of the table.

Continue Reading


Entry filed under: Conditional Fomatting, Excel, Formula, MS EXCEL, MSEXCEL, Range. Tags: , , , , , , .

Excel Function – LARGE Text Split with Excel Formula – Part I

10 Comments Add your own

  • 1. Connor  |  May 6, 2008 at 6:04 pm

    Thanks for the tip, Raj. It’s just what I needed.

    =Connor from New York=

  • 2. Bob Excel  |  June 24, 2008 at 10:33 pm

    Thanks for the tip.

  • 3. jason  |  September 9, 2008 at 2:53 pm

    worked great, thanks for the instructions.

  • 4. Worthstream  |  October 21, 2008 at 10:22 am

    Wonderful, thank you 🙂

    Keep in mind that in excel 2003 (and up?) the formula needs a semicolon:


  • 5. nippit  |  December 21, 2008 at 8:38 pm

    Thank you so much. Something i could not think of…..

  • 6. mpb  |  January 11, 2009 at 5:14 pm

    Thanks alot!
    For all those, who have a german version of excel, the formula then is: =Rest(Zeile();2)=0

  • 7. zuhra  |  April 21, 2009 at 4:35 pm

    works like a charm! thanks…

  • 8. Joe  |  March 11, 2010 at 11:23 pm

    Thank you so much! You’re brilliant!

  • 9. Zack Katz  |  August 18, 2010 at 12:17 am

    THANK YOU! Saved a million hours!

  • 10. Bert  |  February 9, 2011 at 1:10 pm

    Got a question from a colleague if I new a way to get Zebra in Excel output. Google pointed me to this post. After translation of de formula in Dutch en replacing , with ; it worked fine.
    Only problem is that when uses in worksheet that already use colored field you overrule them. Or you should exclude these fields (often a column) from the range.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


We have shifted this blog to following new site

We have added more sections for Basics, External Links and Video tutorials

Blog Stats

  • 104,217 hits

%d bloggers like this: