Rudy Deighton

  • Home
  • Inleiding
  • De Toekomst
  • Marketing Platform
    • Delta Media Strategie Modules
    • Online Marketing
    • Delta Social Media
    • Delta Media Service
    • Delta media Platform
    • Delta Marketing Platform
    • Online business marketing
    • Online Business
      • Worth for free now
      • Work from Home 2020
      • Gadgets
      • All about Windows
      • about Whatsapp
      • Whats the
      • About websites
      • New Ways
      • New Way of Watching
      • Virtual
      • Website
      • All about Video
      • How to Use
      • YouTube Info
      • All about Twitter
      • The Best of
      • About Apps
      • Google News
      • For Free
      • About This
      • Need More
      • Why should you
      • Iphone news
      • Interesting News
      • About Amazone
      • Some tips
      • About Netflix
      • All about Music
      • About Facebook
  • Luxury Platform
    • The Indulgence Business site
    • The Luxury Web site
    • The Ultimate Indulgence
    • The Indulgence Site
    • The Ultimate Luxury Information site
    • Online luxury
  • Projecten
    • Global Diamond Security
    • Aqualith Project
    • Delta Online Projects
    • Delta Media
    • Delta Media Projects
    • Crypto info
      • What is Cryptocurrency
      • Delta Media ICO systeem
      • Cryptocurrency Information
      • About miners
      • Best Bitcoin Bokers
      • Overview Cryptocurrency
      • BLOCKCHAIN WEB PLATFORM
      • Delta Media ICO Cryptocurrency
      • Bitcoin Ticker
      • ICO and Cryptocurrency modules
      • Cryptocurrency, Blockchain, Bitcoin modules
      • Delta Buy & Sale Token
      • Buy and sell digital currency module
      • ico – Crypto BlockChain Parallax module
      • Exchange Cryptocurrency module
  • Nieuws Platform
    • RegioTV Nieuws
    • Regionaal Nieuws Platform
    • Nieuws Regio’s Tiel
    • RegioTV Buren
    • RegioTV Neder-Betuwe
    • Regionaal Nieuws Tiel
    • Micro Locals Nieuws
    • Micro Locals project
    • Lokale CSM systeem
    • RegioTV nieuws
    • Politiek Nederland
    • Politiek Gelderland
    • Politiek Tiel
    • Regio Nieuwsberichten Tiel
    • Regionaal nieuws
    • Regionaal video nieuws
    • RegioTV Nieuws & info
    • Regio Nieuws
    • Online video nieuws
    • Online Nieuws
    • Nieuws online RegioTV
    • Regionale content video
  • Promotion
  • Delta Media
    • Delta Media
    • Adverteren grote fraude
    • Menu POS
    • Delta Global Security
    • Delta Evenementen
    • LinkedIn
    • Facebook
    • Facebook Group
    • Twitter
    • Terms & Policy
    • Contact
    • .
  • Ads prices
    • Online Blog promotion price
    • Online web sites prices
    • Global Promotion Platform
  • Home
  • Delta Media News
  • How to Highlight Every Other Row in Excel
January 24, 2021

How to Highlight Every Other Row in Excel

How to Highlight Every Other Row in Excel

by rudy deighton / Friday, 01 January 2021 / Published in Delta Media News

Making data more readable is a good way to increase your efficiency with little effort. If you are working with a lot of data in Excel, highlighting every other row can make it easier to find an item. This formatting can also give your spreadsheets a more professional look and feel.

Here, we’ll cover multiple ways to color every other row in Excel to get you started.

How to Change the Color by Selecting Every Other Row

The most intuitive way to change the color is to select a row and fill in the cells with the color of your choice.

To select a row, click on the row number on the left-hand side of the screen. You can also select multiple cells or rows by holding the Ctrl key while selecting them.

To change the color, go to the Home tab and select Fill Color, which looks like a paint bucket icon, in the Font group.

Clicking on the dropdown menu by the paint can icon lets you choose from a large selection of colors—you can even find more colors with the More Colors option.

This is an easy way to color every other row in Excel, but it does have some limitations.

It can be time-consuming when working with a large table. The color is also hard-coded to those cells, so if you change the location of the cells by applying a sort or filter, the colors move too.

Instead, you’re better off creating alternating colors in an Excel Table.

How to Create Alternating Colors in an Excel Table

The best way to color every other row in a spreadsheet is to use the table features in Excel. If you format your entries as a table, you can use built-in color formatting templates with them.

To do this, select the option Format as Table from in the Styles group of the Home tab.

Tables have many different formatting options. Once you find the best style for your table, click on it. Excel prompts you to select the cells you wish to apply the formatting to.

It’s that simple!

This method has several advantages over the previous one. If you manipulate the data in the table, the color formatting doesn’t change. It’s also much quicker to color a large amount of data.

Tables also have some additional features that can be useful. Once you convert your data to a table, you should notice that some dropdown menu icons appear in the table headings. These menus give you quick access to search and sort functions.

Related: How to Create a Dropdown List in Microsoft Excel

Adding Custom Formatting to Your Table

There are many pre-built designs to choose from with Excel tables and you can also create your own custom design.

To create a custom style, select New Table Style… from the Format as Table dropdown menu. A popup menu presents more options to let you really fine-tune your table’s style:

  • Add formatting to the Whole Table to apply it to all of the cells.
  • Stripe refers to the alternating colors. They can be added to the columns or the rows.
  • If you want a color to appear on multiple rows before alternating to the next color, you can increase the Stripe Size.
  • The Advanced Style features also allow you to customize the first or last row or column. The first row is referred to as the Header Row, and the last row is the Total Row.
  • You can add special formatting to the first or last cell in the Header or Total row.

These advanced features offer a lot more customization. The only limitation is that the body of the table is limited to two alternating colors.

How to Color Every Other Row in Excel With Conditional Formatting

Conditional formating requires a little more work, but it offers the most freedom to create custom styles, including three or more alternating colors.

Let’s start by looking at how to create two alternating shaded rows:

  1. Begin by selecting the data range you wish to style.
  2. Click on Conditional Formatting in the Styles group on the Home tab.
  3. Select New Rule… from the dropdown menu. This brings up a popup menu.
  4. Select the Rule Type that allows you to use a formula.
  5. Enter the formula: =MOD(ROW(),2)=1
  6. Click on the Format… button and choose formatting for the odd rows.
  7. When you are done, click OK to exit the formatting menu and click OK again to exit the Rule Formatting menu.

Every second row should now have the formatting that you chose. To get the most out of this method, let’s break down how it works.

The first equals (=) sign indicates that we are entering a formula. This is similar to how you enter formulas into cells in a spreadsheet. The rule requires a formula that can evaluate a cell. If our formula returns true, the formatting will be applied.

We want our formula to be based on the position of the cell. To access information about where the cell is, we use the function ROW(). It returns the row number of the cell. Now, we can check if the cell row is an odd number, and if it is, add our formatting.

There is no function that can tell us if a number is odd or even. But, Excel does have the function MOD(). MOD stands for modulus. Remember when you learned division as a kid? Before you learned how to divide using decimals, you would have used remainders. Modulus is the value of the remainder of a number after division.

Related: Amazingly Useful Spreadsheet Templates to Organize Your Life

To check if a number is odd, we can use modulus. If a number divided by two has a remainder of one, it must be odd. In our formula, the first parameter in MOD is the number we are checking (the row number) and the second parameter is the number we are dividing by (two).

The last part of the formula creates the condition. If MOD(ROW(), 2) equals one, then we apply the formating. This seems like a lot of work compared to the previous example, but it can give you more options than table formatting. For example, you aren’t limited to alternating between only two colors.

Creating a Table With Multiple Alternating Colors in Excel

With rule formatting, we can use as many alternating colors as we wish. The only trick is to keep track of the order. Modulus can help with that. It can tell us more than if a number is odd or even. For example, perhaps we want three alternating colors.

We could use the formula =MOD(ROW(),3)=0 to select every row divisible by three. Similarly, if we use the formula =MOD(ROW(),3)=1 it would select the next row. And =MOD(ROW(),3)=2 would select the row after that.

Using this method, we can have as many colored alternating rows as we wish.

Formatting Can Improve Readability

With all the different formatting options available, it can be tempting to go a little crazy with colors. But remember, less is sometimes more. That’s definitely true for formatting.

Focus on adding features that improve readability. Consider what types of information you need to scran for the most. Once you know what information you need to highlight, you’ll be able to determine the best method to format your data.

MakeUseOf – Feed

  • Tweet
Tagged under: Every, Excel, Highlight

About rudy deighton

What you can read next

For the Latest in Tech Trends, Follow MakeUseOf’s IFA Coverage (Sep 4-8)
How to Make Your Own LED Ring Light for YouTube Videos
You Can Soon Make Microsoft Edge Look Fancy

Rudy Deighton Corporate Blog

  • How to Fix the 0xc00007b Error in Windows

    Along with a slew of new features, Windows upda...
  • Your Microsoft Account: 5 Things Every Windows User Should Know

    Your Microsoft account is Microsoft’s sin...
  • Italy Limits Access to TikTok Following a Child’s Death

    Italy is cracking down on TikTok after a 10-yea...
  • Apple Watch Helped Police Find a Kidnapping Victim

    This guide is available to download as a free P...
  • Adobe Photoshop for iPad vs. Affinity Photo for iPad: Which Is Best?

    Adobe Photoshop is the go-to when it comes to i...
  • Microsoft U-Turns Over Xbox Live Gold Price Hike

    Users of Microsoft’s Xbox Live Gold servi...
  • The 10 Best CES Products You Can Buy Right Now

    CES often grabs headlines for its wacky concept...
  • Future Siri Could Recognize How Far Away Your Voice Is

    Since Siri made its debut in 2011 with the iPho...
  • What Is Thread and What Does It Mean for Your Smart Home?

    Included in Apple’s HomePod mini is a new...
  • Pinterest Now Pins "Stories" to the Top of Your Feed

    You didn’t read that wrong. Even Pinteres...
  • Microsoft’s To Do App Now Uses AI to Predict Your Schedule

    If you struggle to draw up a schedule for a giv...
  • Locked Out? How to Reset Your PlayStation Password

    If you’re trying to get into your PlaySta...
  • Looking to Stream Your Nintendo Switch Gameplay? Llano Microdock 3-in-1 Offers Charge, HDMI Out, and Capture

    Llano MicroDock for Nintendo Switch 9.00 / 10 R...
  • Learn How to Become a Better Leader With This Online Course

    It’s not easy to be an effective leader. ...
  • Google Calendar on the Web Gets Offline Support

    We’ve all been there. You’re trying...
  • Report: The Entire iPhone 13 Lineup Will Use Sensor-Shift OIS

    Apple will reportedly bring one of the best pho...
  • Apple’s Next Fitness Challenge Celebrates Black History Month

    Apple’s next fitness challenge will invite Appl...
  • First Wearable Blood-Glucose Tracker Could Save Millions of Lives

    Did a startup invent the holy grail of health w...
  • Joe Biden Invites Everyone to His Inauguration Via Snapchat

    The inaugural committee behind US President-ele...
  • Remember the Banned PS5 Faceplate Seller? It’s Back…

    You may feel like you’re experiencing déj...
  • Microsoft Launches Native Microsoft Edge Beta for M1-Based Macs

    It’s good news for macOS users, as Micros...
  • Parler Is Back Online, But It’s Still Unusable

    After Amazon Web Services dropped Parler for la...
  • How to Sign Out of Netflix on Your Smart TV

    Netflix is available on every device under the ...
  • HBO Max Continues to Offer 20% Off Subscriptions

    If you’ve been thinking of signing up to ...
  • 6 Useful iPhone Group Chat Tips You Should Know

    Engaging in iMessage group conversations can be...
  • How To Protect Yourself From Fraudulent Stores on Shopify

    Shopify, an affordable e-commerce platform used...
  • How to See Who Viewed Your Instagram Posts

    Instagram has been the internet’s favorit...
  • How to Edit Videos on Windows 10

    Editing videos on a Windows PC isn’t as difficu...
  • What Is Facebook’s Collab App and How Do You Use It?

    If you want to do more than scroll through your...
  • GUI? What Is a Graphic User Interface?

    GUIs are ubiquitous, yet you may not even know ...
  • How to Change the Background Color on an Instagram Story

    Looking for a way to personalize your Instagram...
  • How to Secure Freelance Work on Reedsy’s Marketplace

    How to Secure Freelance Work on Reedsy’s ...
  • iMac Is Due To Receive Its First Design Upgrade Since 2012

    It’s a testament to the iMac that, despit...
  • WhatsApp Delays New Privacy Policy After Facebook Data Sharing Controversy

    WhatsApp is now delaying the implementation of ...
  • The 7 Best Gaming Chairs in 2021

    Summary List 8.20/10 1. Premium pick: Vertagear...
  • Epic Games Files New Legal Complaint Against Apple

    The battle between Apple and Fortnite-maker Epi...
  • Google Officially Owns Fitbit: What That Means For You

    Google took to The Keyword to announce that its...
  • Samsung’s New Galaxy SmartTag Has Some Serious Shortcomings

    Samsung has entered into the tracking device se...
  • Oculus Quest to Get Account Sharing Features

    Want to share your Oculus Quest or Quest 2 with...
  • ASUS Updates Dual-Screen ZenBook Duo’s With New Intel CPUs

    2020 was the year of the dual-screen smartphone...

DELTA MEDIA ONLINE MARKETING PLATFORM
An Arte di Riunire Investments GmbH Division

Office:
Delta Media

Arte di Riunire Investments GmbH

Address: Lood 207F

Postcode: 3803 Beatenberg (Swiss)

email: rudydeighton@hotmail.com

rudydeighton@deltamediagbe.com

 

 

Online Platform

Menu POS Systeem

  • GET SOCIAL
Rudy Deighton

© 2014 Delta Media - Arte di Riunire Investments GmbH Division - SWISS All Rights Reserved

TOP