Joe Levi:
a cross-discipline, multi-dimensional problem solver who thinks outside the box – but within reality™

How to use conditional formatting to shade every other row in Excel

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:



You may also like...

Leave a Reply