How to Alternate Row Color in Google Sheets [Guide 2022]

How to Color Alternate Rows in Google Sheets 19

In this article, we are going to study some formatting features of Google sheets that show how to color alternate row in Google sheets. Now in Google Sheets it is quite easy to color alternate rows because there is a separate option in the Google sheets tab menu for alternating colors which is not found in other software.

As Google Sheets is providing their users formatting features to make their documents beautiful and presentable in which color alternate rows is one of them in which you may highlight the rows with different colors to make your document more attractive, it can be used for separation of rows as well or other purposes as you desire.

Why we need Alternate Row Colors in Google Sheets?

Google sheets is an online web-based spreadsheet program providing the features of editing and calculating or analyzing some kind of financial data etc. We may not forbid that there is no need of formatting our documents. Besides, it is essential sometimes to make documents more presentable, so there you might need this feature to color alternate rows in Google sheets.

By coloring alternate rows you may highlight your data or table and can make it easily readable and to find something. It also helps to show separately individual rows in your data. There are so many scenarios where you may need to color alternate rows as you required.

See also  FIX Formula Parse Error in Google Sheets [Guide-2022]

How to Alternate Row Color in Google Sheets

Alternate Row Color in Google Sheets – using Alternating Colors option

As I told you in Google sheets, it is quite easy to color alternate rows because Google sheet provides a separate option in its tab menu to color alternate rows within a few clicks but there are some more customization options in the “Alternating Color” dialogue box which we will discuss in detail. And here I will also teach you a conditional formatting method to color alternate rows or any row you want to color or highlight. So let’s start without wasting our time

Step 1

First we will take some sample of data and select it all

How to Color Alternate Rows in Google Sheets 1

Step 2

Go to the tab menu “FORMAT” and find “Alternating Colors” and click it to open

How to Color Alternate Rows in Google Sheets 2

Step 3

A dialogue box or a pop-up window will appear on the right side of your Google sheets where you will find some customization options

How to Color Alternate Rows in Google Sheets 3

Step 4

Now in just a few clicks you may color alternate rows, First select the color you want to apply and then just click “Done” as you may see below

How to Color Alternate Rows in Google Sheets 4

Step 5

As you may see that you are done now, your rows have been colored alternatingly.

How to Color Alternate Rows in Google Sheets 5

Alternate Row Colors in Google Sheets – Alternating Colors Additional Options

As you have seen how quick it is done in just a few steps although there are so many customizations in Alternating colors you should know them so let’s do a brief discussion one by one,

Cell range

First, we find cell range in the Alternating Colors dialogue box where you may insert cell range or an area where you want to apply the alternate colors rows

How to Color Alternate Rows in Google Sheets 6

Styles

This is a very good and useful option available in Alternating Colors consisting of two buttons with a checkbox “Header” and “Footer”. As we usually have in our data or a table, headings at the top and conclusion in the bottom like total etc. in bill or etc. Sometimes we need to highlight them, or sometimes we do not need to color or highlight them, it also depends on our preferences that How we want to format our document

How to Color Alternate Rows in Google Sheets 7

So you don’t need to worry at all just you may do it by one click on it by checking or unchecking the box, your headings will highlight if you checked the header button or it will not if unchecked the same button similarly for the footer.

Default Styles

In the next section, we find some styles by default formatted of different colors tones, from which you may choose any of them you like

How to Color Alternate Rows in Google Sheets 8

Customs Styles

If you don’t like any of the default styles so in just the next section you may customize it with your own desire, You may change the color of every row what you want like

How to Color Alternate Rows in Google Sheets 9

Here we have completely learned the “Alternating colors” in Google sheets we learned how to color alternate rows and also we learned the all customization of alternating colors. With all above lesson there will not be any problem to color alternate rows, It will help you in all scenarios.

See also  How to Apply a Formula to an Entire Column or Row in Google Sheets

Alternate Row Color in Google Sheets – using Conditional Formatting

Yet! I have covered my topic in the above lesson about how to color alternate rows in Google sheets but there is one more method by which you may color not only alternate rows but also any row that you want to color. Google sheet inserts the option of alternate colors later it used to be done by conditional formatting before. Our topic is related to color alternate rows but by this method we may also color every third or fourth row in our data sheet. This method is a little complex because of using syntax for rows but we will study it with complete guidance and examples so you may learn and can easily apply it to your documents.

Syntax

=MOD(ROW(),2)-1=0

This formula is used to get the row numbers.MOD formula is used to divide the specified divisor which is number 2 in the above syntax and the remainder will be 1 because we are writing the formula to color alternate row or every other row

Similarly, if we want to color the row in such a pattern that every third row will be colored then the syntax will be

=MOD(ROW(),3)-1=0

And similarly further so on you may customize as you want, let’s start with step by step procedure,

Step 1

As usual, first, take a sample of data and select all of the data you have

How to Color Alternate Rows in Google Sheets 10

Step 2

Similarly go into the “FORMAT” tab from the menu and find open the “Conditional Formatting” just above the alternate colors

How to Color Alternate Rows in Google Sheets 11

Step 3

A pop-up window or dialogue box for Conditional formatting will appear on the right side of the Google sheets

How to Color Alternate Rows in Google Sheets 12

Step 4

Now it is time to apply conditional formatting by selecting first “format rules”.

How to Color Alternate Rows in Google Sheets 13

Step 5

Select the format rule to “Custom formula rule” because we will insert the formula manually for rows that we want to color

How to Color Alternate Rows in Google Sheets 14

Step 6

There you will found another box where you will write you customs formula

How to Color Alternate Rows in Google Sheets 15

Step 7

Now you will find little difficulty while inserting formula but once you understand the logic it will be pretty easy, If you want to color alternate rows then the syntax will be

=MOD(ROW(),2)-1=0

Write the formula in the formula bar

How to Color Alternate Rows in Google Sheets 16

Step 8

Now simply press the “Done” button

How to Color Alternate Rows in Google Sheets 17

Step 9

Here, you may see the result you have colored alternate rows

How to Color Alternate Rows in Google Sheets 18

Alternate Row Color in Google Sheets – Color Every Third or Fourth row

If you want to color every two rows of three then repeat the same above procedure just change the syntax like,

=MOD(ROW(),3)-1=0

How to Color Alternate Rows in Google Sheets 19

You may see in the above picture that every third is highlighted or colored. In such a manner you may further customize or color your rows and make your document beautiful and presentable.

Tips:

You may also do some more formatting by this conditional formatting method,

  • You may also use some default formulas and conditional formatting rules
  • Firstly you may select any of the colors that you want to color your rows.
  • You may also Bold, Italic, and underline your text.
  • You may also change font styles by this formatting.
  • There is a strike-through button that is also available to strike through the text.

Here you may find all these options

How to Color Alternate Rows in Google Sheets 20

See also  How to Apply Google Sheets Conditional Formatting If Cell Contains Formula

Alternate Row Color in Google Sheets – How to Remove Conditional formatting

Once you have applied conditional formatting and then if you want to remove the customization to retrieve your documents in their original condition so you may easily delete them within a few steps let’s see

Step 1

Go to the “FORMAT” tab in the menu and go to the “Conditional Formatting” from the drop-down menu

How to Color Alternate Rows in Google Sheets 21

Step 2

A pop-up window will open on the right side of your Google Sheet where you will find a pane saved of your editing as you may see below.

How to Color Alternate Rows in Google Sheets 22

Step 3

To delete this formatting simply move the cursor to the pane of formatting, You will see a trash button press it to delete the formatting as you may see in the picture

How to Color Alternate Rows in Google Sheets 23

Step 4

Now, close the formatting window

How to Color Alternate Rows in Google Sheets 24

Step 5

You have successfully deleted the all formatting rules now here is your document in its original condition

How to Color Alternate Rows in Google Sheets 25

Important Notes

  • If you have formatted your cells or colored your cells or rows already and then you apply the “Alternating colors” or “Conditional Formatting” so it will be overwritten on it, your previous editing or formatting will be hidden automatically.
  • Once you apply “Alternating colors” or “Conditional formatting” on a table or rows and then you expand it to more rows so it will automatically adjust the color pattern and similarly if you delete your data as well

See also  How to Freeze a Row and Column in Google Sheets

Conclusion

As we find how to color alternate rows in Google sheet is very useful to make our documents beautiful and presentable. This is why I wrote this article in which I covered all scenarios to color alternate rows and as well every third or fourth row by the Alternating colors method and Conditional formatting method. I hope you understand better with my given examples and shall not have any problem while applying the above conditions or formatting to your data.

Thankfully don’t forget to give thumbs up, like, and subscribe.

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

We will be happy to hear your thoughts

Leave a reply

OfficeDemy.com
Logo
Enable registration in settings - general