Automatic Row Shading

J

John Harris

Is there a way to shade every other rown in a spreadhseet besides selecting
each row while holding ctrl down? Just looking for a shortcut to do this.
Seems someone at MS would have thought of an easy way to format the
spreadsheet in this manner and I am just to dumb to figure it out.

TIA
 
K

Ken Macksey

Hi

Use conditional formatting. Select the area to be shaded, select format
menu, conditional formatting, Formula is and enter formula

=IF(MOD(ROW(),2)=0,TRUE,FALSE) to shade even # rows

or

=IF(MOD(ROW(),2)=1,TRUE,FALSE) to shade odd # rows

and select the color by clicking format button, click shading tab and select
a color.
Then click Ok and Ok buttons.

HTH

Ken
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shading A Line Using Accent, etc. Why Other Changes Also ? 1
Formatting As Table with OUT header row formatting 5
shade every other row, automatically 5
conditional formatting with color- five rows at a time? 1
EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS 3
Shaded for every other row 2
Shading in table 1
Shading row based on value in one of its columns 1

Top