The following are the basics of using Spreadsheet Shader macro
This macro colours alternating lines in a Worksheet selection to aid the user reading the data when it is printed out.
The result, based on the defaults above:
The columns can be shaded instead of the rows as shown below using single line groups.
As the default area is the currently selected range, by selecting different areas and changing the line counts, different patterns can be created. For example, in the picture below, the week column was performed using a 7:7 line pattern, the day column was performed using a 3:4 line pattern.
Created with the Personal Edition of HelpNDoc: Easily create EPub books