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