Excel Formulas to Highlight the Alternating Groups of N Rows!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-04-21 06:19:32

---
title: Excel Formulas to Highlight the Alternating Groups of N Rows!!
published: true
date: 2021-04-09 06:01:43 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-highlight-the-alternating-groups-of-n-rows/
---

In Excel, it is easy to **[highlight every other row](https://geekexcel.com/excel-formulas-to-highlight-every-other-row-easy-tutorial/)**. But, have you ever tried to color the rows alternately based on a certain group. Today, I can introduce a simple formula to **highlight the alternating groups of N rows in Excel**. Let’s see them below!! 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 alternating groups](https://geekexcel.com/wp-content/uploads/2021/04/Highlight-alternating-groups.png)](https://geekexcel.com/excel-formulas-to-highlight-the-alternating-groups-of-n-rows/highlight-alternating-groups/#main)<figcaption id="caption-attachment-22871">Highlight alternating groups</figcaption>

## General Formula:

- If you want to highlight rows in groups of “n” in Excel, you can use the below formula.

**=[ISEVEN](https://geekexcel.com/steps-to-use-iseven-function-in-microsoft-excel-365-simple-way/)([CEILING](https://geekexcel.com/how-to-use-excel-ceiling-function-in-office-365-with-examples/)([ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)()-offset,n)/n)**

## Syntax Explanations:

- **ISEVEN** – In Excel, this function will help to 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/)**.
- **CEILING ** – The **[CEILING function](https://geekexcel.com/how-to-use-excel-ceiling-function-in-office-365-with-examples/)** is used to round a given number to the nearest specified multiple.
- **ROW** – In Excel, the **[ROW function](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)** helps to return the row number for reference.
- **N** – It represents the grouping values.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example.

- First, we will enter the input values in **Column B** to **Column D**.
- Here we are going to highlight the alternative group values.

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

- So apply the above-given 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/)**
- Finally, we will get the result as shown below.

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

## Wind-Up:

We have described the simple formula to **highlight the alternating groups of N rows in Excel from this short tutorial**. Hope you like it. Please feel free to state your query or feedback for the above article. To learn more, check out **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas to Highlight the Duplicate Columns ~ Easy Steps!!](https://geekexcel.com/excel-formulas-to-highlight-the-duplicate-columns/)**
- **[Excel Formulas to Highlight Entire Rows With Certain Condition!!](https://geekexcel.com/excel-formulas-to-highlight-entire-rows-with-certain-conditions/)**