Arrow left
Back to product guides
Google Sheets Tips

How to Alternate Row Colors in Google Sheets

In this article, you will learn how to color rows with alternating patterns in Google Sheets. This Google Sheets function allows you to make your data table more visible and clear.

How to use the “Alternating color” function in Google Sheets

  1. Select an array you want to apply an alternating pattern.
  2. Go to the “Format” tab → “Alternating colors”.
  3. The pop-up menu shows up on the right side.
  4. Determine if you apply a pattern to “Header” and “Footer”.
  5. Choose a pattern you like out of default patterns, or customize your design.
  6. Click the “Done” button at the bottom right.

Steps 1 and 2

How to show a pop-up menu of the “Alternating colors” from the menu bar

Steps 3 to 5

How to choose a pattern or customize your pattern in the “Alternating colors” menu

What is the alternative way of “Alternating colors”

You can use Conditional Formatting instead of Alternating colors to alternate row colors. 

  1. Select the range you want to apply a pattern.
  2. Navigate to the “Format” tab → “Conditional formatting”.
  3. Choose “Custom formula is” → Enter “=MOD(ROW(),2)=0”.
  4. Click the “Done” button at the bottom right.
How to use Conditional Formatting to alternate row colors

Alternating column colors by Conditional Formatting

You need to understand that you make the MOD function return 0 (where a row number is even) or 1 (when a row number is odd) by entering 2 as its divider and that the Conditional Formatting you define is applied where the MOD function returns 0. In the example, Conditional Formatting is effective for rows with even numbers. If you want to apply Conditional Formatting to rows with odd numbers, you can change the custom formula to “=MOD(ROW(), 2)=1”. You can see the outcome in the picture below.

How to adjust a custom formula for Conditional Formatting to alternate row colors differently

How to alternate column colors in Google Sheets

Check this article: Alternate Column Colors in Google Sheets: Explained to learn how to add alternating colors to columns.

Other tips related to Conditional Formatting

If you don’t get the right answer to your question in this article or you have other questions related to Conditional Formatting, you may find the answers in the following articles.

Conditional Formatting in Google Sheets: Explained

Conditional Formatting Based on Another Cell Value in Google Sheets: Explained

How to Highlight Duplicates in Google Sheets

Analyze your live financial data in a snap

Are you learning this tip to build a financial KPI dashboard? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711