«

»

Nov 12

Formatting Sets Of Rows

Use this formula with Conditional Formatting to highlight alternating sets of 5 rows: =MOD(CEILING(ROW(),5),2)