G
Guest
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)+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.
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.
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)+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.
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.