Excel Formulas to Highlight Every Other Row ~ Easy Tutorial!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-03-30 12:04:47

---
title: Excel Formulas to Highlight Every Other Row ~ Easy Tutorial!!
published: true
date: 2021-03-30 04:26:22 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-highlight-every-other-row-easy-tutorial/
---

Adding color to alternate rows or columns can make it easier to read the contents of the spreadsheet. Here, we will show the simple formula to **highlight every other row in a table** with a conditional formatting option in Excel. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

![Highlight every other rows](https://geekexcel.com/wp-content/uploads/2021/03/Highlight-every-other-rows.png)<figcaption id="caption-attachment-22728">Highlight every other row</figcaption>
## General Formula:

- You can use the below formula to highlight every other row in Excel.

**Highlight Odd Rows =**** [ISODD](https://geekexcel.com/use-isodd-function-in-microsoft-excel-365-simple-methods/)([ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)())**

**Highlight Even Rows =[ISEVEN](https://geekexcel.com/steps-to-use-iseven-function-in-microsoft-excel-365-simple-way/)([ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)())**

## Syntax Explanations:

- **ISODD** – In Excel, the [**ISODD Function**](https://geekexcel.com/use-isodd-function-in-microsoft-excel-365-simple-methods/)returns **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** when a numeric value is odd, and **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** for even numbers.
- **ISEVEN** – This function will return **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)**when a numeric value is even, and **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** for odd numbers. Read more on the **[ISEVEN Function](https://geekexcel.com/steps-to-use-iseven-function-in-microsoft-excel-365-simple-way/)**.
- **ROW** – The [**ROW Function**](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/) helps to return the row number for reference.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Let’s consider the below example.

- First, we will enter the input values in **Column B** to **Column E**.
- Now we need to highlight every other row from this input range.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/03/Input-Ranges-38.png)<figcaption id="caption-attachment-22729">Input Ranges</figcaption>

- Apply the **“highlight odd row” formula** in the conditional formatting option.
- To know  **how to apply conditional formatting**  in Excel, just **refer to this article<u>:</u>[ How to Apply the Formula with Conditional Formatting In Excel?](https://geekexcel.com/how-to-apply-formula-with-conditional-formatting/)**
- Now, it will highlight the odd rows from the table and display the result as shown below.

![Result 1](https://geekexcel.com/wp-content/uploads/2021/03/Result-1-4.png)<figcaption id="caption-attachment-22730">Result 1</figcaption>

- You can also use the **“Highlight even row”** formula for adding the color to the even rows in Excel.

![Result](https://geekexcel.com/wp-content/uploads/2021/03/Result-42.png)<figcaption id="caption-attachment-22731">Result</figcaption>

## Verdict:

Hope you like this article on how to **highlight every other row in Excel**. If you have any other ideas or question, do share with us here in the comments section below. Thank you for visiting our site!! To learn more, check out **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Highlight the Dates in Same Month and Year!!](https://geekexcel.com/excel-formulas-to-highlight-the-dates-in-same-month-and-year/)**
- **[Excel Formulas to Highlight Dates in Next N Days From Today!!](https://geekexcel.com/excel-formulas-to-highlight-dates-in-next-n-days/)**