• 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
Excel

How to alternate row colors in Excel

0 Comments

How to alternate row colors in Excel: When working with long spreadsheets with numbers in Excel, the chances of getting confused between rows are high. To overcome this situation, you should color alternate rows to facilitate observation and calculation. Follow the article below to learn how.

Step 1

To color alternate rows, first, open the Excel file that needs to be colored. Then, select the entire data range that needs to be colored, and choose the Home tab on the toolbar. Next, click on Conditional Formatting in the Styles section. A scroll bar appears, then choose the New Rule option.

How to alternate row colors in Excel

How to alternate row colors in Excel

Step 2

Now, the New Formatting Rule dialog box appears. Click on the Use a formula to determine which cells to format under Select a Rule Type. Then, enter the formula =MOD(ROW();2)>0 in the Format values where this formula is true field. Next, click on Format… to select a color.

How to alternate row colors inStep 3

Now, the Format Cells dialog box appears. Select the Fill tab. Then, choose the color you want to fill in the Background Color section. Finally, click OK to complete.

How to alternate row colors in Excel

How to alternate row colors in Excel

That’s it, the data range you selected earlier is now colored with alternate rows.

How to alternate row colors in Excel

How to alternate row colors in Excel

Step 4

If you want to change the color, just choose the Home tab on the toolbar. Then click on Conditional Formatting. A scroll bar appears, then choose Manage Rules.

How to alternate row colors in Excel

How to alternate row colors in Excel

Step 5

Now, the Conditional Formatting Rules Manager dialog box appears. Select the formula you created earlier, then choose Edit Rule.

How to alternate row colors in Excel

How to alternate row colors in Excel

Step 6

The Edit Formatting Rule dialog box appears, select Format… and then choose the color you want to change.

How to alternate row colors in Excel

How to alternate row colors in Excel

Thus, the above article has instructed you on how to alternate row colors in Excel. Hopefully, this article will be helpful to you in your work. Wish you success!

Rate this post
33
280 Views
How to convert Excel files to CSV easily and memorablyPrevHow to convert Excel files to CSV easily and memorablyApril 7, 2023
2 Simple ways to extract the integer part of a number in ExcelApril 7, 20232 Simple ways to extract the integer part of a number in ExcelNext

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
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • 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
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
Products
  • Microsoft Visio 2019 professional Key Global Bind to your Microsoft Account Microsoft Visio 2019 professional Key Global Bind to your Microsoft Account
    Rated 4.96 out of 5
    $12.00
  • Windows Server 2019 Remote Desktop Services 50 USER Connections Key Global Windows Server 2019 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.75 out of 5
    $20.00
  • Windows Server2008 R2 Remote Desktop Services user connections (20)cal Windows Server2008 R2 Remote Desktop Services user connections (20)cal $29.00
  • Microsoft Office 2019 Home and Student for PC Key Global bind to your Microsoft account Microsoft Office 2019 Home and Student for PC Key Global bind to your Microsoft account
    Rated 4.95 out of 5
    $58.00
  • Microsoft Project 2016 professional CD Key Global Microsoft Project 2016 professional CD Key Global
    Rated 4.97 out of 5
    $9.00
  • Microsoft Project 2019 Professional Key Global Microsoft Project 2019 Professional - 5 PC
    Rated 4.97 out of 5
    $12.00
  • microsoft office home and business 2019 pcmac key Microsoft Office Home And Business 2019 (MAC) key bind to your Microsoft account
    Rated 4.95 out of 5
    $30.00
  • Microsoft Visual Studio Enterprise 2019 For 1 PC Microsoft Visual Studio Enterprise 2019 For 1 PC
    Rated 4.88 out of 5
    $15.00
  • 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
  • Office 2024 Home And Business For Mac/Pc Bind Office 2024 Home And Business For Mac/Pc Bind $99.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.