Google Sheets can add alternating colors without manually formatting every other row. Use Alternating colors for a quick fixed range, table formatting for structured data that grows, or conditional formatting when you need blank-row handling, alternating columns, grouped rows, or checkerboard patterns.
The best method depends on whether the range is static, whether new records will be added, and whether the color pattern must follow custom logic. The four approaches below cover ordinary banded rows as well as advanced layouts.
Key takeaways
- Use Format → Alternating colors when you need quick banded rows on a normal, defined range.
- Use a Google Sheets table when structured data will grow and your account provides table formatting.
- Use conditional formatting with a custom formula when the range is open-ended or blank rows, starting rows, columns, or business rules matter.
- A formula such as
=ISEVEN(ROW())follows absolute sheet row numbers, so an anchored formula is usually safer when data starts below row 1. - Parity-based rules can color blank rows and can change appearance after sorting, inserting, or deleting rows unless the formula accounts for those cases.
4 Ways to Add Alternating Colors in Google Sheets
| Need | Best method | Why |
|---|---|---|
| Quick striping on a fixed report or list | Built-in Alternating colors | No formula is required and the colors are easy to change. |
| A maintained, structured dataset that will grow | Google Sheets table | Table formatting includes dedicated alternating-color controls and table styles. |
| An open-ended range or custom row logic | Conditional formatting | The rule can use formulas, exclude blank records, and cover future rows. |
| Alternating columns, blocks, or checkerboards | Advanced conditional formatting | Row and column numbers can control patterns that the basic command does not provide. |
How do you use the built-in Alternating colors command?
The built-in Alternating colors command is the simplest way to create ordinary banded rows. Use it when you want one color on a row, another color on the next row, and no special rule based on cell values.
Desktop steps
- Open the spreadsheet.
- Select the range to format, such as
A1:F50orA2:F50. - Open the formatting menu and choose Alternating colors.
- Choose a preset in the side panel.
- Adjust the Header color, First color, and Second color settings as needed.
- Click Done.
Select A1:F50 when the first row is the header of the banded range and should receive separate header styling. Select A2:F50 when row 1 already has its own formatting and the striping should begin with the first data row.
#1 Best Overall
How do you change or remove the colors?
To change the appearance, select a cell in the formatted range and reopen the Alternating colors controls. Choose another preset or customize the header and alternating fills. On supported desktop browsers, Google Sheets supports custom colors through preset colors, HEX values, RGB values, or the eyedropper; the Google Sheets custom-color help page documents those color options.
To remove the banding, select the formatted range, open the alternating-colors controls, and use the option to remove the alternating colors. Removing the formatting does not delete the cell contents.
When is the built-in method the right choice?
Use the native command for a static report, a small list, or any range where visual striping matters more than custom logic. The method needs no formulas and is easy for beginners to maintain.
The main limitation is range management: the formatting applies to the selected range, so do not assume that every row added outside that range will automatically receive the same styling. If the range will expand regularly, consider a table or an open-ended conditional-formatting rule.
How do you add alternating colors with a Google Sheets table?
A Google Sheets table combines banded formatting with table structure, making it a useful option for inventory, project trackers, contact lists, sales data, and task registers that are maintained over time.
Google’s table-formatting documentation describes controls including Show alternating colors, Change alternating colors, custom table styles, header and footer options, gridline controls, and condensed view.
Desktop steps
- Select the data range.
- Use the Sheets command to convert the range to a table.
- Open the table menu.
- Choose Table formatting.
- Enable Show alternating colors.
- Choose a default style or create a custom style.
- Adjust the header, footer, gridline, condensed-view, and alternating-color settings if necessary.
Converting a range to a table automatically applies basic formatting. The table menu lets you show, remove, or change alternating colors, and the Table formatting sidebar supports custom styles. A table can be reverted to unformatted data without deleting the data, but converting a range changes how Sheets manages that range.
Are Google Sheets tables available to every account?
No. Google’s current documentation says table functionality is available only to certain work or school accounts, so the table option may be missing from some personal accounts or Workspace configurations. If the command is unavailable, use built-in Alternating colors or conditional formatting instead.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Choose a table when the dataset has a meaningful table structure and will be maintained as records are added or changed. Do not convert a simple range to a table solely to obtain stripes if you do not want the additional table behavior.
How do you use conditional formatting for alternating rows?
Conditional formatting is the most flexible formula-based method. Google Sheets evaluates a custom formula and applies the selected style when the result is TRUE; Google documents the desktop workflow in its conditional-formatting help page and describes background and foreground formatting in the Sheets API conditional-formatting documentation.
Basic even-row striping
- Select the range, such as
A2:F. - Choose Format → Conditional formatting.
- Under Format cells if, choose Custom formula is.
- Enter
=ISEVEN(ROW()). - Choose a fill color.
- Click Done.
The formula =ISEVEN(ROW()) shades even-numbered sheet rows. To shade odd-numbered sheet rows instead, use:
=ISODD(ROW())These are valid custom-formula patterns, not official one-size-fits-all banding formulas. Google documents the custom-formula mechanism; the correct formula depends on the selected range and the row where the pattern should begin.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
How do you make the pattern start at a specific row?
When the first data row is row 2 and that row should be the first band in the pattern, apply the rule to A2:F and use a formula relative to row 2:
=ISEVEN(ROW()-ROW($A$2)+1)To reverse the phase so the first data row receives the other color, use:
=ISODD(ROW()-ROW($A$2)+1)The $A$2 reference anchors the starting point. If the data begins in row 5, replace $A$2 with $A$5. The formula and the applied range must agree about the first data row; otherwise, the first stripe may appear on the wrong row.
How do you leave blank rows unformatted?
A parity-only formula colors every matching physical row, including empty rows. Add a test against a column that reliably identifies a record:
PC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minute=AND($A2<>"",ISEVEN(ROW()-ROW($A$2)+1))Apply the rule to a range such as A2:F. The formula leaves rows blank when column A is blank. If column A is not the record-identifying column, replace $A2 with a suitable test column.
An open-ended range such as A2:Z is convenient for future rows, but the blank-row test is important if the sheet contains unused space. Otherwise, the rule can shade empty rows far below the current dataset.
How do you create two explicit alternating colors?
A single conditional-formatting rule normally applies one chosen style when its condition is true. For two explicit conditional colors, create two rules on the same range:
- Use
=ISEVEN(ROW()-ROW($A$2)+1)for one color. - Use
=ISODD(ROW()-ROW($A$2)+1)for the other color.
Assign a different fill to each rule. In many sheets, a simpler arrangement is to apply one light base fill to the range and use one conditional rule for the alternate rows.
Why might conditional formatting be preferable?
Conditional formatting is preferable when the range should extend into future rows, when blank rows should remain plain, or when the pattern must be combined with other logic. The trade-off is precision: the applied range, anchored references, and formula must align, and an excessively large range can make the sheet harder to manage.
How do you create alternating columns, grouped rows, or a checkerboard?
Advanced conditional formatting uses row and column numbers to create patterns that the standard Alternating colors command does not offer.
Alternating columns
Select a range such as A2:Z100, choose Format → Conditional formatting, select Custom formula is, and use:
=ISEVEN(COLUMN()-COLUMN($A$2)+1)This shades every second column relative to column A. To shade the first, third, fifth, and subsequent columns, use:
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →=ISODD(COLUMN()-COLUMN($A$2)+1)The anchor establishes the starting column; the rule applies across the selected range.
Alternating groups of three rows
To alternate three-row blocks beginning at row 2, apply this rule to the desired range:
=ISEVEN(INT((ROW()-ROW($A$2))/3))The formula treats rows 2–4 as one group, rows 5–7 as the next group, and rows 8–10 as the following group. To alternate groups of another size, replace 3 with the desired group size.
To leave blank records unformatted while retaining the physical three-row grouping, use:
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Fix the driver behind crashes, sound loss and screen glitches3Clear out junk files and repair common Windows errors=AND($A2<>"",ISEVEN(INT((ROW()-ROW($A$2))/3)))This formula is position-based. Deleting or inserting blank rows changes the grouping because the physical row positions change.
Checkerboard pattern
For a checkerboard effect across a rectangular range, use:
=ISEVEN(ROW()+COLUMN())Apply the rule to the desired range. Cells are colored when the combined row and column numbers produce an even result. A second complementary rule can color the other cells if two explicit fills are required.
What if the colors should follow values instead of positions?
Row and column parity creates position-based patterns. If colors should follow a category, status, date, approval state, or record identity, use a value-based conditional-formatting formula instead. Position-based striping can change after sorting, filtering, inserting, or deleting rows; a value-based rule is more appropriate when the color belongs to the record rather than its current position.
Which alternating-color formula should you use?
| Purpose | Formula | Important condition |
|---|---|---|
| Shade even sheet rows | =ISEVEN(ROW()) |
Uses absolute sheet row numbers. |
| Shade odd sheet rows | =ISODD(ROW()) |
Uses absolute sheet row numbers. |
| Alternate rows from row 2 | =ISEVEN(ROW()-ROW($A$2)+1) |
Apply the rule beginning at row 2. |
| Alternate rows from row 2 with the opposite phase | =ISODD(ROW()-ROW($A$2)+1) |
Apply the rule beginning at row 2. |
| Exclude blank records in column A | =AND($A2<>"",ISEVEN(ROW()-ROW($A$2)+1)) |
Column A must identify whether a record exists. |
| Alternate columns from column A | =ISEVEN(COLUMN()-COLUMN($A$2)+1) |
Apply across the range whose starting column is A. |
| Alternate three-row groups | =ISEVEN(INT((ROW()-ROW($A$2))/3)) |
Groups are based on physical row positions. |
| Checkerboard pattern | =ISEVEN(ROW()+COLUMN()) |
Apply to a rectangular range. |
How do you add alternating colors on a phone?
Google’s Android help documentation includes both Alternating colors under cell formatting and conditional formatting in the Sheets app. Mobile labels and layouts can vary by app version and platform, so the controls may not look exactly like the desktop interface.
Android
- Open the sheet in the Google Sheets app.
- Select the cells to format.
- Open the cell-formatting controls and choose Alternating colors when available.
- For a formula-based rule, open the formatting options, choose Conditional formatting, and create a custom formula rule.
Google documents Android cell formatting, including the Alternating colors option, in its Android formatting guide. The Android conditional-formatting workflow and custom-formula support are described in Google’s Android conditional-formatting guide.
iPhone and iPad
Do not assume that iOS has exactly the same labels or menu placement as desktop or Android. If a control is unavailable or difficult to manage on mobile, apply the formatting in the desktop web version of Google Sheets.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.How do you fix common alternating-color problems?
The first row has the wrong color
The formula may be using the sheet’s absolute row number rather than the first row of the selected data. Apply the rule to the correct starting range and anchor the formula to that row, such as $A$2 for data beginning in row 2. Also verify whether the header is included in the formatted range.
Recommended Free Tools
Blank rows are colored
A formula such as =ISEVEN(ROW()) intentionally evaluates row positions, so empty rows can receive the fill. Add a record test such as $A2<>"", and choose a column that is blank only when the row contains no record.
New rows do not match
Check whether the new rows are inside the range formatted by the native command. Built-in Alternating colors is tied to the selected range, so rows added outside that range may not inherit the appearance. A table may be a better fit for structured expanding data, while an open-ended conditional-formatting range such as A2:Z can cover future rows. Open-ended rules should exclude blanks when necessary.
Another rule changes the fill
Open Format → Conditional formatting and inspect the existing rules and their applied ranges. Status, duplicate, overdue-date, priority, or approval rules may use their own background or text colors. Keep row striping subtle and consider text color, bold text, or borders for status indicators so important meaning is not hidden by the stripes.
Conditional-formatting rules can set both background and foreground colors, as described in Google’s Sheets API documentation. Avoid assuming that one kind of formatting always overrides every other kind; inspect the actual rules and styles in the sheet.
Free tools Windows power users keep installed
One-click scans. No signup required.
Best Value
Copying and pasting disrupted the formatting
Copying formatting or pasting cells can introduce, replace, or alter formatting rules. Inspect the conditional-formatting rules and each applied range before recreating the sheet’s formatting. Narrowing a rule to the actual data area can also make inconsistent results easier to diagnose.
The table option is missing
Table features are not universal across all Google accounts. Google currently qualifies table availability for certain work or school accounts. If the table command is unavailable, use the built-in Alternating colors command for simple banding or conditional formatting for expanding and formula-controlled ranges.
Which Google Sheets alternating-color method should you choose?
Most beginners should select the range and use Format → Alternating colors. The native command is fast, readable, and sufficient for a fixed list or report.
Choose a Google Sheets table when the range represents a structured dataset that will be maintained and expanded, provided the feature is available in the account. Choose conditional formatting when you need an open-ended range, blank-row exclusion, alternating columns, grouped rows, a checkerboard, or a rule connected to values.
Use a low-contrast banding color when the same cells also need status, duplicate, date, or priority highlighting. Alternating colors can help readers scan rows, but striping should not obscure more important information or be treated as a universal accessibility solution.
Frequently Asked Questions
Does Google Sheets automatically extend alternating colors to every future row?
Google Sheets does not provide one blanket guarantee that every method will format every future row forever. Built-in Alternating colors is associated with the selected range, tables have their own formatting behavior, and conditional formatting can cover future rows when its applied range is open-ended.
How do I alternate colors while leaving blank rows white in Google Sheets?
Use conditional formatting with a record test, such as =AND($A2<>"",ISEVEN(ROW()-ROW($A$2)+1)), applied to A2:F. Replace column A with the column that reliably indicates whether a row contains data.
Why does sorting change my Google Sheets row colors?
Position-based formulas assign colors from the current physical row number, so sorting, inserting, or deleting rows can change which records receive each color. Use a value-based conditional-formatting rule when the color should stay tied to a category or record value.
Can Google Sheets alternate colors by column instead of by row?
Yes. Apply conditional formatting to the target range with a formula such as =ISEVEN(COLUMN()-COLUMN($A$2)+1). The formula alternates columns relative to column A.
The Bottom Line
For a normal fixed range, use Alternating colors. For a structured dataset that grows, use table formatting when your account supports it. For open-ended ranges or nonstandard patterns, use conditional formatting with a formula anchored to the correct starting row and, when necessary, a test that excludes blank records.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
