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

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.

**Excel - Highlight every 3rd row**

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

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

Chapters:

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