Shade groups of rows with conditional formatting

Tip: Shade groups of rows with conditional formatting

In this video, we’ll look at how to use conditional formatting to shade alternating groups of rows. For example, you can use this approach to shade groups of 3 rows, groups of 4 rows, and so on. This can be a nice way to make certain tables easier to read.

Here we have a table with 3 rows of data for each client, for the months April, May, and June.

Let’s use conditional formatting to highlight these rows to match the data. We can do this with a formula that groups rows by three’s.

Duration 
3:01
Author 

Related shortcuts

Leave a Reply

Your email address will not be published. Required fields are marked *