Colour Even Rows
Enter the following into Conditional Formatting, Formula Is and select a colour by pushing Format, Patterns.
=EVEN(ROW())=ROW()
Alternative formula is
=MOD(ROW(),2)=0
© Copyright 2004 - 2007,
andrewsexceltips.com
. All Rights Reserved.