Spreadsheets are great, but sometimes my eyes get lost in the seemingly endless meres of data.
Row shading can come in handy, but it’s very tedious to apply formatting to every other row, and more so when an odd number of rows (even just one) needs to be inserted — thereby throwing off your scheme.
Microsoft KB Article 268568 contains instructions on how to do this programmatically. Here’s the code:
=MOD(ROW(),2)=1
