How do I shade alternate rows in Excel 2002?

G

Guest

I used to be able to do this quite easily in Lotus 123 eight years ago. How
can I do this without having to individually select alternate rows to shade
in a large spreadsheet?
 
G

Guest

In cell A1 go to Format, Conditional Formatting.
Under Condition 1 choose Formula Is and type =row(a1)/2=int(row(a1)/2).
Click Format, click the Patterns tab, choose your shading colour, click OK
and click OK again.
Copy the format to all the other cells.
 

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 rows in excel 10
how can I shade alternate rows in Excel 2007? 3
Use VBA to shade every 3 rows (banding) 6
shade rows 2
Shade alternate VISIBLE rows only 8
How can I shade each alternate Excel row without selecting each? 4
how do I shade alternating rows in spreadsheet 7
shade alternating rows in excel 2

Top