How to create zebra stripes with conditional formatting

This is sometimes called “zebra striping”.

In this spreadsheet, we have a table of employees with a small amount of formatting.

This is a good option, especially if you want the table for other reasons as well.

However, you might also apply dynamic zebra striping with conditional formatting and a formula.

The classic formula for zebra striping uses the MOD function.

MOD takes a number and a divisor, then returns the remainder.

So, instead of this MOD formula, I could just use ISEVEN with ROW.

To shade odd, rows, I just need to replace ISEVEN with ISODD.

The formula is simply + ROW + COLUMN, wrapped in ISODD or ISEVEN.