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.