Having followed a link kindly offered by Pascal in the thread "Banding formats", the section headed How to shade rows with three different colours, has left me somewhat confused, and unfortunately I am some days away from testing the following concepts within an excel sheet.
To highlight 1st and 3rd rows use Mod(Row($A2)+3-1,3)=1.
To highlight 2nd, 6th, 9th etc use Mod(Row($A2)+3-1,3)=2.
To highlight 3rd, 7th, 10th etc use Mod(Row($A2)+3-1,3)=0.
The only value that differs between the formulas is the end value ( 1,2,0) yet the requirements are significantly different. What is it that tells Excel the band value?
Secondly, given that the starting cel is always $A2, the +3-1 does what?