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
andrewsexceltips.net
All Rights Reserved.