• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Software tricks/tips

Change the color in Google Sheets with just 2 clicks

0 Comments

Have you ever wanted to quickly alternate row colors in Google Sheets with just 2 clicks? Buffcom.net will show you how to do it using the built-in feature. This is a new feature recently added by Google Sheets to help users perform tasks more quickly.

Previously, you had to use conditional formatting to achieve this, but now you can do it with just 2 clicks. Additionally, this article also explains the conditional method for those who need to alternate 3 or 4 rows.

How to quickly alternate row colors in Google Sheets:

Assuming you already have a data table like the one below and you want to highlight/alternate row colors:

Google Sheets 1Below are the steps:

Step 1. Select all cells in the data table (including the header).

Step 2. Go to the “Format” tab.

Google Sheets 2Step 3. Select “Alternating colors”.

Google Sheets 3Step 4. In the Alternating colors panel on the right, follow these instructions:

In the Styles option, make sure you have ticked the Header box. If your data table does not have a header, untick this box.

Choose one of the available templates, or you can also customize the colors for Header, Color 1, and Color 2 as desired.

Google Sheets 4Completing these steps will alternate the row colors in Google Sheets as shown below:

Google Sheets 5To remove the alternating color, select any cell in the data table, go to the Format tab, and select Alternating colors. A control panel will open, where you can choose “Remove alternating color”.

Some things to keep in mind when using the Alternating colors feature in Google Sheets:

If you have already colored the data cells, using the Alternating colors feature will override the existing colors. When you remove the new color, the old color will remain.

If you want to change the color of a specific header or data cell, you can manually change it. This will override the existing color.

If you expand the data table and insert additional rows, Google Sheets will automatically highlight every other row with the selected color. However, when you delete a data row, the color will still remain and you have to manually delete it.

How to alternate color 3 or 4 rows in Google Sheets

To alternate color rows, the above method is the best and fastest. But if you don’t want to alternate every other row and instead want to alternate 3 or 4 rows at a time, what do you do?

For this case, you need to use the Conditional Formatting feature along with a simple formula.

Assume you have a data table like the one below and you want to alternate color every 3 rows in this table:

Google Sheets 6Here are the steps:

Step 1. Select the data table that you want to alternate color every 3 rows (excluding the header).

Step 2. Select the Format tab.

Google Sheets 7Step 3. Select the Conditional formatting option. This action will open the Custom Formatting panel on the right.

Google Sheets 8Step 4. In the Format rules menu, scroll down and select “Custom formula is”.

Google Sheets 9Step 5. In the “Value or Formula” box below, enter the following formula: =MOD(ROW(),3)-1=0.

Google Sheets 10Step 6. Select the formatting type. You can alternate color every 3 rows or bold, italicize, etc.

Google Sheets 11Step 7. Select Done.

Performing the above steps will apply the selected format/color to alternate every 3 rows in Google Sheets.

That’s the guide on how to alternate row color in Google Sheets in a snap.

Hopefully, through this article, you will know how to alternate row color in Google Sheets using the Alternating colors feature. If you have any questions or feedback, please leave a comment for Buffcom.net. Wish you success.

Rate this post
36
266 Views
How to add the Permanently Delete option to the Windows 11/Windows 10 context menuPrevHow to add the Permanently Delete option to the Windows 11/Windows 10 context menuMarch 8, 2023
Tips to increase the capacity of drive C that everyone should knowMarch 8, 2023Tips to increase the capacity of drive C that everyone should knowNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Products
  • Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.74 out of 5
    $15.00
  • Project Standard 2021 Microsoft Project Standard 2021 - 1 PC $13.00
  • Microsoft Visual Studio 2022 Professional Key Microsoft Visual Studio 2022 Professional Key $19.00
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Visio Professional 2024 Visio Professional 2024 $33.00
  • Kaspersky Total Security 2021 1 year 1 device key Global Kaspersky Total Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $27.00
  • Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year $284.73
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Kaspersky Total Security 2021 1 year 5 devices key Global Kaspersky Total Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $46.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.