Colour Set Rows
Enter the following into Conditional Formatting, Formula Is and select a color by pushing Format, Patterns.
=MOD(ROW(),3)=0
colours every 3rd row and
=MOD(COLUMN(),4)=0
will colour every 4th column
© Copyright
andrewsexceltips.net
All Rights Reserved.