3

I've got a long list of data (export from MySQL) that I want to print out to tick each row after I've done stuff with it. Is there an easy way in Excel 2010 on Windows to make the table zebra-backgrounded for better readability? I've found some solutions that use conditional formatting, but that doesn't seem to work in Excel 2010. Also, my Excel is in German and the English formula commands do not work.

2
  • 1
    Why not just use Format as Table from the Home tab and select a design with alternating colors? Or am I misunderstanding the question.
    – James P
    Oct 17, 2012 at 11:49
  • I didn't know about it. That's exactly what I'm looking for. Thanks.:)
    – simbabque
    Oct 17, 2012 at 12:00

2 Answers 2

6

Fastest way I have found is to select your data and click the Format as Table button on the Home Ribbon. Choose the style you want.

enter image description here

6

If you need a better control over your style, and all you need is just a zebra, then do this:

  1. Select the rows you want to format.
  2. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click New Rule.
  3. In the New Formatting Rule dialog box, under Select a Rule Type, click Use a formula to determine which cells to format.
  4. In the Format values where this formula is true box, enter =MOD(ROW(),2)=0
  5. Click Format, choose your formatting, and apply it.

Full instructions are here: https://support.office.com/en-za/article/Apply-shading-to-alternate-rows-in-a-worksheet-9e77c551-0bcf-4515-9497-fdbf724de9be

I can only guess in German version of Excel: MOD(ROW(),2) will be REST(ZEILE(),2)

For English-German translation use this: http://www.piuha.fi/excel-function-name-translation/index.php?page=english-german.html

2
  • The correct German Excel formula is REST(ZEILE();2) . I tried to edit, but the change was rejected as being too short ... duh . Short syntax errors really exist!
    – Peter G.
    Dec 19, 2017 at 14:24
  • I love this way!
    – Nam G VU
    Aug 15, 2020 at 13:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .