How do I apply shading/color to every other row

[TomR]

Often times a length table or spreadsheet is difficult to read, even
with printed grid lines. I have seen many reports having every other
row shaded or colored lightly. I wanted to do this with excel but it
seems that the only way to do it is to apply the format to each
individual row one at a time. I cannot believe that this program does
not have an option for this, but it does not, as far as I can see. Do
any of you have a solution to this that does not involve formating
every other row on a 5-600 row spreadsheet?

Thanks so much

Tom in New Orleans

[Denny Campbell]

Tom,

See "Color Banding With Conditional Formatting" at Chip Pearson's excellent
site:

http://www.cpearson.com/excel/banding.htm

--
Denny Campbell
Grand Rapids, Michigan

"TomR" <tru...@home.com> wrote in message
news:F3B20EE5CF784D86.7FD79AAE...@lp.airnews.net...

[Dave Peterson]

If you're using xl97 or xl2k, take a look at Chip Pearson's:

http://www.cpearson.com/excel/banding.htm

TomR wrote:
>
> Often times a length table or spreadsheet is difficult to read, even
> with printed grid lines. I have seen many reports having every other
> row shaded or colored lightly. I wanted to do this with excel but it
> seems that the only way to do it is to apply the format to each
> individual row one at a time. I cannot believe that this program does
> not have an option for this, but it does not, as far as I can see. Do
> any of you have a solution to this that does not involve formating
> every other row on a 5-600 row spreadsheet?
>
> Thanks so much
>
> Tom in New Orleans

--

Dave Peterson
pete...@netzero.net

[Patrick Molloy]

Chip's site is excellent, but for those that don't have web access...

select the area/table or entire sheet
select Format / Conditional Formattinfg...
for ODD numbered rows
change 'Cell Value Is' to 'Formula Is' and type
=MOD(ROW(),2)=1
click Format and select a pattern - choose a light blue pastel color, select
the Borders tab and select all borders
click OK
If you want to ADD for even numbered rows, click ADD
change Cell Value Is to Formula Is and type
=MOD(ROW(),2)=0
and hit Format, choosing a different color, and set the borders
click OK twice to close the forms.

HTH

"TomR" <tru...@home.com> wrote in message
news:F3B20EE5CF784D86.7FD79AAE...@lp.airnews.net...

[Tom Ogilvy]

>I cannot believe that this program does
> not have an option for this,

Your right, it does have an option for this.

If you have a table of data, look at Format=>Autoformat.

Look at List1 or 3D Effects2

Regards,
Tom Ogilvy