Transaction export cleanup
Paste CSV, apply alternating colors with a dark header row, and ship to finance the same day without manual styling.
What are alternating colors in Google Sheets?
Alternating colors apply banded row or column fills to a table so eyes track across wide grids. Format > Alternating colors opens a sidebar with presets and custom header and footer styles. It is faster than hand-painting every other row and updates when you add rows inside the formatted range.
When to use it
Use alternating colors on long operational tables, printable reports, and client deliverables where scanability matters: rosters, transaction logs, and inventory lists.
When to skip it
Skip banding when conditional formatting already encodes meaning with status colors, or on tiny tables where banding adds noise without benefit.
How it works
-
1
Select your table including headers, then Format > Alternating colors.
-
2
Pick a preset style or set custom colors for header, band one, band two, and optional footer.
-
3
Check whether banding applies to whole rows or a fixed column range inside the selection.
-
4
Add new data rows inside the formatted block so banding continues automatically.
-
5
Remove banding from Format > Alternating colors > Remove alternating colors when you switch to a theme.
-
6
Combine with freeze panes and bold headers so the table reads professionally in meetings.
Examples in Google Sheets
Classroom grade sheet
Banded rows help teachers follow one student across ten assignment columns during parent conferences.
Inventory audit
Footer style highlights the total row while body rows alternate light gray and white for warehouse printouts.
Build this without starting from a blank cell
Use a Better Sheets tool for Alternating colors, then watch a walkthrough when you want the full pattern.
Better Sheets resources
Common mistakes
- Banding a range that includes blank spacer columns, creating odd visual gaps.
- Stacking alternating colors on top of heavy conditional formatting so cells turn unreadable mud colors.
- Applying banding to A:A on a million-row sheet for no reason, hurting scroll performance.
- Forgetting to extend the range when the table grows, leaving new rows unbanded at the bottom.
- Using low-contrast band colors that disappear on projectors and in grayscale PDF export.
Frequently asked questions
- Alternating colors vs conditional formatting?
- Alternating colors is structural zebra striping. Conditional formatting reacts to cell values and rules.
- Custom band colors?
- Yes. Use the sidebar to set header, color 1, color 2, and footer independently.
- Alternating colors on pivot?
- Pivot tables have their own theme. Apply banding on raw data tables or presentation copies.
- Remove banding?
- Select the range, Format > Alternating colors, then Remove alternating colors.
- Banding and sort?
- Bands follow row order after sort, which is usually what you want for readability.
- Copy banding to another tab?
- Copy formatted range and paste special formatting, or redefine alternating colors on the new table.
- Alternating columns instead of rows?
- Some presets band by column. Pick the style that matches how readers scan your layout.
- Explore suggested banding?
- Explore can suggest alternating colors on a selection. Same feature as the Format menu path.
Related Tutorials
Watch how Alternating colors works
DarkSide of Google Sheets - Creating Dark Mode and Making it Better!
Whitening Google Sheet Prank
10 Things I Hate About Your Spreadsheets
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets
The First Thing I Do When Starting a Google Sheet
Related blog posts
Guides that explain Alternating colors in more depth.
Google Sheets Green Color Hex Code
Google Sheets Green Color Hex Code! Dive into #0F9D58, Google's vibrant shade of Green. The green color code you'll want to use in all your designs if you're google sheets adjacent.
Read post →How to Use Alternating Colors to make a Summary Page
Learn how to use Alternating Colors, avoid formula parse errors, and design impressive Google Sheets.
Read post →5 More Fixes For Your Spreadsheets
Hi, Andrew Kamphey here with Better Sheets, dedicated to helping you improve your Google Sheets every single day. Last time, I shared five ways to fix your sheets. So now, I've got five more tips to make your sheets even better. Let's dive right in! Change the Background Color Let's start by talking about color. While changing the font color is important, altering the background color can make a significant difference too, just follow these steps: 1. Select the entire background. 2. Hit...
Read post →Related glossary terms
spreadsheet styling
Styling is the visual layer on top of raw data: fonts, fills, borders, banding, and theme colors that guide the eye to headers, inputs, and totals. Unlike number formatting, styling does not change values. It makes shared sheets scannable in meetings and reduces "where do I type?" questions from new editors.
Read guide →cell formatting
Cell formatting controls how values display without necessarily changing the stored value underneath. Currency, percent, date, and plain text formats keep reports readable and prevent Sheets from auto-converting IDs into dates. Good formatting is the difference between a sheet leadership trusts and one they argue with.
Read guide →conditional formatting
Conditional formatting changes how cells look when they meet rules you define, such as values above a target or dates in the past. It helps scanners spot problems fast without writing values into extra helper columns. Rules can be simple comparisons or custom formulas that reference other sheets.
Read guide →dashboards
A dashboard is a single view that answers "how are we doing?" without hunting across tabs. In Google Sheets, it is usually a summary tab with big numbers, charts, and conditional formatting fed by QUERY, pivot tables, or IMPORTRANGE from raw data you keep elsewhere.
Read guide →Done reading about Alternating colors?
Membership unlocks 636+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.