Excel is a popular spreadsheet program for data organization. You can not only edit data in millions of ways, but you can also change how it is displayed.
You may need to tint cells in different colors at times. This can help to make tables and data set simpler to understand. This tutorial will demonstrate how to darken every other row in Excel.
Before we begin, you’ll need some data to work with so that you can follow along. Begin by opening a document that has the table or data that you wish to use as an example.
After completing the instructions below, you will be able to darken every other row in an Excel document.
How to Shade Every Other Row in Excel?
To shade every other row in Excel:
- Highlight all of the data containing the rows you want to shade.
- Navigate to the Home tab in Excel.
- Click Conditional Formatting under the Styles section.
- Choose the New Rule option.
- Go to “Use a formula to determine which cells to format.”
- In the blank field, type in =isodd(row()) to highlight every odd row.
- Tap on the Format button.
- In the Fill tab, select a color for the Background Color.
- Select OK twice to apply the Background Color to every odd row.
This lesson employs a one-of-a-kind function to choose every odd row from a previously defined array of data.
The =isodd function chooses just odd values from a data collection, and we’re directing it to select every odd row in this example.
We then use Conditional Formatting to fill the rows with a certain color.
You may select any color, style, font, or text size from this menu. We chose a plain gray hue for its simplicity.
When dealing with financial accounts and documentation, it is customary practice to highlight every other row. You now understand how to darken alternate rows in Excel!