hi,
i am not sure what you mean. if you mean greenbar paper,
you need a greenbar printer. if you mean doing in on excel
and printing it then do this
Formulas For Color Banding

The formulas for odd banding and even banding are very
similar.
For odd banding, use the formula

=MOD(ROW()-Rw,N*2)+1<=N

where Rw is the first row number that is to be formatted,
and N is the number of rows
in each color band. In the example shown on the right
above, Rw is 8, and N is 3.

For even banding, use the formula

=MOD(ROW()-Rw,N*2)+1N

where Rw is the first row number that is to be formatted,
and N is the number of rows
in each color band. In the example shown on the right
above, Rw is 8, and N is 3.

To use these formulas in Conditional Formatting, select
the cells that you want to format.
Then, go to the Format menu, and choose Conditional
Formatting. In this dialog, change
Cell Value Is to "Formula Is", and enter one of the
formulas above.

In both formulas, you can either put it literal values for
Rw and N, or you can create defined
names and store the value there. An advantage to using
defined names is that you can
change to band height very easily. To shade alternate
rows, simply change N to 1.
To shade in bands of 5, change N to 5.

And because the Conditional Formatting formulas are not
moved with the cells when
you sort a range, the bands will remain intact after the
sort.



-----Original Message-----
I would like to make reports appear on greenbar paper
from yester years
instead of plain paper. I have been during it manually
and am hoping there is
a way or a template to run.
.

http://www.cpearson.com/excel/banding.htm
At Chip Pearson's site

--
Regards,
Tom Ogilvy

wrote in message
...
hi,
i am not sure what you mean. if you mean greenbar paper,
you need a greenbar printer. if you mean doing in on excel
and printing it then do this
Formulas For Color Banding

The formulas for odd banding and even banding are very
similar.
For odd banding, use the formula

=MOD(ROW()-Rw,N*2)+1<=N

where Rw is the first row number that is to be formatted,
and N is the number of rows
in each color band. In the example shown on the right
above, Rw is 8, and N is 3.

For even banding, use the formula

=MOD(ROW()-Rw,N*2)+1N

where Rw is the first row number that is to be formatted,
and N is the number of rows
in each color band. In the example shown on the right
above, Rw is 8, and N is 3.

To use these formulas in Conditional Formatting, select
the cells that you want to format.
Then, go to the Format menu, and choose Conditional
Formatting. In this dialog, change
Cell Value Is to "Formula Is", and enter one of the
formulas above.

In both formulas, you can either put it literal values for
Rw and N, or you can create defined
names and store the value there. An advantage to using
defined names is that you can
change to band height very easily. To shade alternate
rows, simply change N to 1.
To shade in bands of 5, change N to 5.

And because the Conditional Formatting formulas are not
moved with the cells when
you sort a range, the bands will remain intact after the
sort.



-----Original Message-----
I would like to make reports appear on greenbar paper
from yester years
instead of plain paper. I have been during it manually
and am hoping there is
a way or a template to run.
.