Spreadsheets are a handy tool, but sometimes you want to make them easier to read by adding alternating colors to each row (e.g. white and grey).

Formatting zebra stripes in Microsoft Excel is easy: you select the rows you want to color, click on “Tables” in the ribbon, and preso, you’ve got a nicely formatted table.

Formatting a spreadsheet in Google Sheets is a bit more complicated. It doesn’t have Microsoft’s built in formatting tools, but you can still achieve that effect by using conditional formatting and a simple formula.

Digital Inspiration’s post “How to Color Alternate Rows in Google Sheets” shows you how.