How to Alternate Row Colors in Google Sheets (Zebra Stripes)

By Gerard Fernandez · Updated · 3 min read

Alternating row colors (also called banding or zebra stripes) make long tables much easier to read: your eye can follow a row across the screen without jumping to the one below. Google Sheets has a built-in tool for it, and it takes about ten seconds.

Add alternating colors

  1. Select your table, including the header row.
  2. Go to Format → Alternating colors (Alternating colours if your account uses UK English).
  3. A panel opens on the right. Pick one of the Default styles, or set your own colors under Custom styles.
  4. Keep Header ticked if the first row is a header, and click Done.
Google Sheets Alternating colors panel for A1:C8 with Header ticked, the green default style selected, and Header, Color 1 and Color 2 under Custom styles
Real test: the panel lets you pick a style and choose separate colors for the header, the two stripes and an optional footer.
An expense table with a green header row and alternating white and light green rows
Real test: the result with the green style and Header ticked.

The stripes are part of the range: if you sort the data or insert rows inside it, the pattern stays even. We sorted this same table by Amount, and the rows moved while the stripes stayed in order (see the result in how to sort data).

  • Header gives the first row of the range its own, darker color. Leave it ticked if your data has column names: you'll need it later if you want to convert the range into a table.
  • Footer colors the last row differently, which is handy for a totals row.

Change or remove the colors

Click any cell in the range and open Format → Alternating colors again. Pick another style, click the color circles next to Header, Color 1 and Color 2 to choose your own, or click Remove alternating colors at the bottom of the panel.

Every other column, or groups of rows

The built-in tool only stripes rows one by one. For other patterns, use conditional formatting with a custom formula:

PatternCustom formula
Every other column=ISEVEN(COLUMN())
Blocks of 3 rows=ISEVEN(INT((ROW()-2)/3))
Only rows with data=AND($A1<>"", ISEVEN(ROW()))
Visible rows only (works with filters)=ISEVEN(SUBTOTAL(3, $A$2:$A2))

To apply one: select the range, open Format → Conditional formatting, choose Custom formula is, paste the formula and pick a fill color. Write the formula for the first row of your selection; Sheets adjusts it for the other rows.

Converting the range into a table

Getting an error when you choose Format → Convert to table? See Fix "You cannot convert an alternating color range without a header format into a table" for the cause and two quick fixes.

Frequently asked questions

Why can't I change the fill color of some cells?

If a fill color doesn't seem to apply, check whether the range has alternating colors or a conditional formatting rule: both can hide the color you choose. Change the colors in the Alternating colors panel, or remove it, and try again.

Do the stripes work with filters?

The built-in stripes follow row numbers, so when a filter hides rows you can end up with two rows of the same color next to each other. If that bothers you, remove the alternating colors and use the "visible rows only" formula from the table above. It counts only the rows the filter shows.

How do I stripe only part of a sheet?

Select just that range before opening the panel. You can check or change the covered cells in the Apply to range box at the top of the panel.

Does it work on the mobile app?

Yes. In the Google Sheets app, select the range, tap the A (format) icon, go to the Cell tab and turn on Alternating colors.

Is there a way to keep the header visible too?

Yes, freeze it. See how to freeze rows.