Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row.

Posted on: 09/23/2022

Conditional Formatting in Excel allows you to highlight every 2nd, 3rd, 4th, or 5th row. Writing a formula using the MOD function and ROW function together allows us to do this.

The MOD Function has two required arguments and shows the remainder after dividing two numbers. For example, =MOD(7,3) will return 1. Three goes into 7 two times with a remainder of 1. Another example of MOD is =MOD(5,3) will return 2.

The ROW function specifics what row you are in. =ROW(), if you are in row 5, it will return 5. =ROW() will return 9 if you are in row 9.

**Conditional Formatting with MOD and ROW function**
**Used to highlight every 3rd row**

YouTube Video

Chapters:

0:00 Intro
0:28 Select quickly
0:47 Examples of MOD and ROW with Conditional Formatting
2:16 MOD and ROW Explained

Recent articles

Excel - Advanced Filters

Excel filters are great for seeing just a subset of your data. You can use filters for text, numbers, and dates, but also by color. You can use font color or fill color (the paint can). You can also use Advanced Filters. You Advanced Filters when you are looking at multiple fields but for different criteria. For example, I want to filter and only see people in Georgia and New York. That is easy to do and can be done with the drop-down filter. But, for Georgia, I want to see people who are Single, and for New York, I want to see Family. That requires an Advanced Filter.

Excel 3D Reference - easily reference data on another worksheet

A 3D reference in Excel is a simple method to pull data from another cell, another worksheet, or a range of worksheets. Changes in the source will reflect in the destination.

Microsoft Word to Adobe Acrobat with Bookmarks

We don't usually want to email, or share are Word files. Frequently, we make our Word documents PDF files. If you lay out your Word document correctly, it is easy to make bookmarks in the PDF.

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate in Word, Outlook, OneNote, and PowerPoint allows users to use speech-to-text to author content in files.

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 16 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube