You can use conditional formatting...

Highlight the section you want to have alternating bands.
Select Format - Conditional Formatting...
Add this formula
=mod(row(), 2) = 0
Now select the desired highlighting shade using Format - Patterns
Select Ok
--
HTH...

Jim Thomlinson


"juji" wrote:

How do I shade alternate rows in excel 2000