Excel 2019 Bible

Chapter 5: Formatting Worksheets

55

Shading groups of rows

Here’s another row shading variation. The following formula shades alternate groups of
rows. It produces four shaded rows, followed by four unshaded rows, followed by four more
shaded rows, and so on.

=MOD(INT((ROW()-1)/4)+1,2)=1

Figure 5.20 shows an example.

FIGURE 5.20

Conditional formatting produces these groups of alternating shaded rows.

For different sized groups, change the 4 to some other value. For example, use this formula to
shade alternate groups of two rows:

=MOD(INT((ROW()-1)/2)+1,2)=1

Working with conditional formats

This section describes some additional information about conditional formatting that you
may find useful.