That will actually color every other row (the EVEN rows) , which is not what
the poster asked for, but color banding is definitely one of the advantages of
Conditional Formatting. You probably have seen Chip Pearson's
page on the subject: http://www.cpearson.com/excel/banding.htm

"Michael" wrote ...
=MOD(ROW(),2)=0