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