shading every other cell

[stacym]

I've created a large reference sheet, and would like every other cel
shaded to make it easier to use. Usually I leave the first row white
shade the second row, then copy both and paste to the rest of the shee
to get the every other cell effect. However, there are a few cells i
my worksheet that are larger than the rest, and when I hit past
special - formats, it changes the size of those cells in addition t
the shading. Is there a simpler way to shade every other cell, or past
some of the formatting without pasting all of it?
Thanks,
Stac

 

[Paul B]

Stacy, Select the range you want to format. Format > Conditional Formatting.
In the left dropdown, change ""Cell Value is"" to ""Formula Is"". In the
formula box type. =MOD(ROW(),2)=0 Click the Format... button. Click the
Patterns tab and pick a color

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Gord Dibben]

Stacy

Check out Format>Autoformat>List1. May be what you want.

Or Select rows to the bottom of your range of data then Format>Conditional
Formatting>Formula is

=MOD(ROW(),2)=1

Format>Pattern shade as you wish.

Gord Dibben XL2002