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.