For future reference http://www.datapigtechnologies.com/f...teshading.html

You can also highlight every 5 rows or whatever number by changing the formula.

Epinn

"Tim" wrote in message ...

Usaing excel 2000, how do I get alternate coloured rows without having to
select and colour each one??

Tim