shade alternating rows in excel

J

JOn K via OfficeKB.com

Matt8301 said:
how do i shade alternating rows in excel without going through one by one?
thanks
Click to expand...
Conditional Formatting will take care of this problem

1) Select your data/range of cells

2) Format > Conditional Formatting

3) Condition 1 > Formula Is > =MOD(ROW(),2)=1, and choose you
formatting

4) Condition 2 > Formula Is > =MOD(ROW(),2)=0, and choose you
formatting
5) Click Ok
 
P

Paul B

Matt, use conditional formatting



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
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

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

how do I shade alternating rows in spreadsheet 7
How do I create alternating row colors in excel? 5
Row Shading 1
How to delete alternating BLANK rows in .xls file all @ once? 3
shading rows in excel 10
coloured roes static while sorting data 3
Cell shading with conditional formatting 5
formula for CF 5

Top