Alternating Colors in Google Sheets (Zebra Stripes)

Alternating colors in Google Sheets add zebra stripes to your data, coloring odd and even rows differently so each row stands out from its neighbors. This makes large tables significantly easier to read, especially when you’re scanning across wide rows.

Google Sheets has a built-in alternating colors feature that takes two clicks. This guide covers that built-in method, how to customize the colors, and a formula-based alternative using conditional formatting.

In This Guide

• How to Add Alternating Colors: Step-by-Step
• Customize the Color Scheme
• Remove Alternating Colors
• Alternating Colors with Conditional Formatting
• Common Issues and Fixes
• Tips and Best Practices
• Related Google Sheets Tutorials
• FAQ

How to Add Alternating Colors: Step-by-Step

Click and drag to select the cells you want to format. Include the header row if you want it styled with a distinct color.

Go to Format > Alternating colors. The Alternating colors panel opens on the right side of the screen. Google Sheets immediately applies a default color scheme (light gray and white) to your selected range.

The panel shows several preset color schemes. Click any preset to apply it. The header row gets a darker shade, and the data rows alternate between two lighter colors.

You can also set custom colors by clicking the color swatches for Header, Color 1 (odd rows), and Color 2 (even rows). Click Done to apply.

Customize the Color Scheme

The built-in presets cover common combinations, but you can set any color you want.

1. Open the Alternating colors panel (Format > Alternating colors).
2. Click the color swatch next to Header, Color 1, or Color 2.
3. Pick a color from the palette, or enter a custom hex code.
4. Click Done.

Good combinations for readability:

Remove Alternating Colors

1. Select any cell within the formatted range.
2. Go to Format > Alternating colors.
3. Click Remove alternating colors at the bottom of the panel.

The colors disappear and cells return to their default white background (or any manually applied colors).

Alternating Colors with Conditional Formatting

If you need more control, like coloring every third row or applying stripes based on a condition, use conditional formatting with a custom formula instead.

Color every even row

1. Select your data range (skip the header row).
2. Go to Format > Conditional formatting.
3. Set the format rules to Custom formula is.
4. Enter the formula:

=ISEVEN(ROW())

5. Set the background color and click Done.

Every row with an even row number gets the background color. Odd rows stay white.

Color every odd row

Use =ISODD(ROW()) instead. Same process, opposite rows.

Color every third row

=MOD(ROW(), 3) = 0

This colors every row where the row number is divisible by 3.

Common Issues and Fixes

Alternating colors don’t appear after inserting rows

If you insert rows outside the original formatted range, the new rows won’t have alternating colors. Select the full range including the new rows, go to Format > Alternating colors, update the range in the panel, and click Done.

Colors disappear after sorting

Alternating colors are tied to the range, not the data. When you sort, the colors stay on the same row positions and the data moves. This is by design. The stripes always alternate regardless of how the data is ordered.

Conditional formatting overrides alternating colors

Conditional formatting rules take priority over alternating colors. If a cell matches a conditional formatting rule with a background color, that color wins. Remove or adjust the conditional formatting rule if you want the alternating color to show.

Tips and Best Practices

1. Apply alternating colors early. Set up the formatting before your data grows. The range expands as you add rows within the formatted area.
2. Keep colors subtle. Light shades (pastels, light grays) work best for alternating rows. Bold colors make the sheet harder to read, not easier.
3. Exclude the header row from the pattern. Use a distinct header color that doesn’t repeat in the data rows. The built-in feature handles this automatically when the Header checkbox is checked.
4. Pair with frozen rows. Freeze the header row so it stays visible while you scroll through color-striped data.
5. Use the formula method for shared templates. Conditional formatting rules copy when you duplicate a sheet. Alternating colors also copy, but the formula method gives you more flexibility for complex patterns.

Related Google Sheets Tutorials

• Conditional Formatting in Google Sheets — Apply color rules based on cell values, dates, or custom formulas
• Color Scale Conditional Formatting — Gradient color scales that shade cells from low to high values
• How to Freeze Rows and Columns — Keep headers visible while scrolling through color-striped data
• Custom Number Formats in Google Sheets — Format how numbers display alongside visual formatting like alternating colors

FAQ

How do I add alternating row colors in Google Sheets?

Select your data range, then go to Format > Alternating colors. Google Sheets applies a default color scheme. Use the panel on the right to choose a preset or set custom colors for header, odd rows, and even rows.

Can I change the colors used for alternating rows?

Yes. In the Alternating colors panel, click any color swatch to open the color picker. You can set separate colors for the header row, odd data rows (Color 1), and even data rows (Color 2).

How do I remove alternating colors in Google Sheets?

Select the range with alternating colors, go to Format > Alternating colors, then click Remove alternating colors at the bottom of the panel.

Do alternating colors adjust when I add or delete rows?

Yes. Alternating colors is a range-based format. When you insert or delete rows within the formatted range, the color pattern adjusts automatically so odd and even rows stay consistent.

Can I use alternating colors with conditional formatting?

Yes, but conditional formatting rules take priority. If a conditional formatting rule sets a background color on a cell, that color overrides the alternating color for that cell.

How do I apply alternating colors with a formula instead?

Use conditional formatting with a custom formula. Select your range, go to Format > Conditional formatting, choose Custom formula is, and enter =ISEVEN(ROW()). Set a background color. This colors every even row.