Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
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 Oct 17 '12 at 11:49
    
I didn't know about it. That's exactly what I'm looking for. Thanks.:) –  simbabque Oct 17 '12 at 12:00

2 Answers 2

up vote 4 down vote accepted

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

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.