I've used the formula:
=MOD(ROW(),2)=0

I'm not very well versed in Excel formulas so forgive my ignorance. What the
difference between =0 and =1?

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"Bernard Liengme" wrote in message
...
Select all the rows you want coloured.
Use Format | Conditional Formatting
Use Formula is: and enter =MOD(ROW(),2)=1
and then set a pattern (colour for the alternate rows)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tim" wrote in message
...

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

Tim