Arrow left
Back to product guides
Google Sheets Tips

Alternate Column Colors in Google Sheets: Explained

In this article, you will learn how to alternate cell colors for every two columns. If you need to learn how to change row color every two rows, check this article: How to Alternate Row Colors in Google Sheets  


What is alternating colors in Google Sheets?

Alternating colors means that you change the cell colors for every two rows or columns with two kinds of colors (e.g., white and light grey). It is often applied to a table or list containing a data set to make each row or column clear so that readers can go through the information easily.

How to alternate column color in Google Sheets

Although you can use the Google Sheets tool to alternate row colors, you need to use Conditional Formatting with a custom formula to alternate column colors. It is not difficult but simple as shown below.

  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(COLUMN(),2)=0”.
  4. Click the “Done” button at the bottom right.
How to use Conditional Formatting to alternate column colors

Alternating column colors by Conditional Formatting

You need to understand that you make the MOD function return 0 (where a column number is even) or 1 (when a column 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 in columns with even numbers. If you want to apply Conditional Formatting to columns with odd numbers, you can change the custom formula to “=MOD(COLUMN(), 2)=1”. You can see the outcome in the picture below.

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

What does the alternating color function do?

Google sheets’ alternating color function allows you to alternate colors easily but only for rows. You can learn how to use the function in the following articles: How to Alternate Row Colors in Google Sheets

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

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