Imagine you want alternating rows (or columns) in a report to have alternating colors. I don’t know, maybe you’re missing the days of tractor-feed paper.
One option is to convert your data in a table (Ctrl+T, or Insert \ Table). Other advantages come with the table like the ability to reference ranges in formulas with names instead of addresses, but the table doesn’t work in all cases (but I definitely should write something about tables soon).
An easy option, if you can’t use tables is to use conditional formatting.:
- Select your data
- Home \ Conditional Formatting \ New Rule
- Use a formula to determine which cells to format
- Use the following formula =ISODD(ROW())
- Set your format, validate, you’re all set (you can also use ISEVEN, and swap COLUMN() for ROW() if you want vertical rather than horizontal stripes).
Try it, you might like it.