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.
1Why not just use Format as Table from the Home tab and select a design with alternating colors? Or am I misunderstanding the question.– James POct 17, 2012 at 11:49
I didn't know about it. That's exactly what I'm looking for. Thanks.:)– simbabqueOct 17, 2012 at 12:00
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.
If you need a better control over your style, and all you need is just a zebra, then do this:
- Select the rows you want to format.
- On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click New Rule.
- In the New Formatting Rule dialog box, under Select a Rule Type, click Use a formula to determine which cells to format.
- In the Format values where this formula is true box, enter =MOD(ROW(),2)=0
- 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