Highlighting a set of alternate rows in your Google Sheets document **makes it much easier to handle your spreadsheet, especially if it has become particularly massive. **It becomes increasingly easy to get lost in the rows and columns of data if you’re not careful, so it’s best to use a visual guide while you use your spreadsheet. In this article, we will show you how to highlight a set of alternate rows in Google Sheets.

##### Table of Contents

Google Sheets has the built-in Conditional Formatting feature that is very useful for ease of data visualization. It makes your spreadsheet not only efficiently organized, but visually appealing as well.

For example, you are hosting a fitness challenge and are keeping track of the contestant check-ins. After a while the list gets so long and the numbers can be so similar – it’s easy to lose track!

**So, how should we proceed?**

To accomplish our goal, we will use a combination of the `ISODD`

, `ISEVEN`

and `ROW`

functions with the Conditional Formatting feature of Google Sheets.

## How to Use Conditional Formatting to Highlight a Set of Alternate Rows in Google Sheets

Here, you can check out conditional formatting automatic solution to highlighting a set of alternate rows in Google Sheets.

- Choose
**Format**from the menu bar. Find and click the option of “**Alternating colors**“.

- From there, Google Sheets will automatically find your data spread and give you options for alternating row choices, including the header.

- Customize how you see fit, and you’re done!

This simple problem can be practiced. Use the link below to use our spreadsheet sample:

## The Anatomy of the ISODD and ISEVEN Functions in Google Sheets

The syntax (the way we write) the `ISODD`

function is simple:

=ISODD(value)

And the `ISEVEN`

function is similar:

=ISEVEN(value)

Let’s break both of these functions down to understand each term:

`=`

the equal sign is how we begin any function in Google Sheets.`ISODD`

or`ISEVEN`

is our function. This is what we will use to determine whether a value, whether inputted as a number or as a cell address, is even or odd.`value`

is the only attribute of this function and

`ISODD`

and `ISEVEN`

are Boolean functions. `ISODD`

will return TRUE if the value is an odd integer or a reference to a cell containing an odd integer, and returns FALSE otherwise. `ISEVEN`

acts the same with even integers.

The syntax of the `ROW`

function is simple:

=ROW([cell_reference])

`=`

the equal sign is how we begin any function in Google Sheets.`ROW`

is our function.`cell_reference`

is the cell whose row number will be returned. This entry is optional, and if you leave the`ROW`

function cell reference blank, the cell in which the formula is inputted will be the default.

We will combine these functions together to highlight a set of alternate rows in Google Sheets.

## How to Highlight a Set of Alternate Rows in Google Sheets

Aside from the automated method in Google Sheets, here is another function that highlights odd and even rows in Google Sheets.

- Choose the
**Conditional formatting**option from the**Format**option on the menu bar.

- The conditional format rules box will pop up on the right side of the screen.

- Select the range you want to apply the alternating rows to take effect.

- After you have chosen the range, from the dropdown of “
**Format rules**,” choose “**Custom formula is**” all the way at the bottom.

- Insert the following formula:
`=ISODD(ROW())`

in the box.

- Customize the formatting style as you wish.

- One set of rows will be properly colored.

- Next, choose the “
**Add another rule**” and add another custom formula, this time with`=ISEVEN(ROW())`

and customize as you like.

- There you have it! 🙌

## How to Highlight Every Nth Row in Google Sheets

Maybe you’re interested to highlight every 3^{rd} or 4^{th} or 5^{th} row in your table, what have you. There is also another way to use Conditional Formatting to return your desired table.

- Choose conditional formatting to add a new rule.

- Add this formula:
`=MOD(ROW(),3)=0`

. Replace N with the number you want. In this example, it’s every 3rd row. Don’t forget to add “=0” at the end, otherwise the effect will be to color every row except the 3rd one!

- Customize as you see fit, and admire your work!

There you have it! You are now able to highlight a set of alternate rows in Google Sheets as you wish, without disturbing the integrity of your data. Now that you have a grasp on how to combine data visualization styles in your spreadsheets, you can combine this with other Google Sheets formulas to make really powerful data documents!