A formula for alternating bands (number 7) can be much easier:
=ISEVEN(ROW()) vs =ISODD(ROW())
Or, more generically: =MOD(ROW()),2) = 0, =MOD(ROW()),2) = 1
The second version may be adjusted to alternate more than 2 formats.
Discussion on:
Message 3 of 22
