Conditional formatting

[WallyZ]

How do I underline every third row in an Excel 2007 worksheet?

 

[Dave Peterson]

=mod(row(),3)=0
or
=mod(row(),3)=1
or
=mod(row(),3)=2

Depending on where you want to start.

See Chip Pearson's site for more info:
http://www.cpearson.com/excel/banding.htm