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.