Select the cells/rows you want to apply this format to. Goto Format,
conditional format. Select "Formula is" from first box. Input:

=MOD(ROW(),2)

Select desired shading color, and hit 'ok'.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"juji" wrote:

How do I shade alternate rows in excel 2000