Conditional formatting

[WallyZ]

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

 

[akphidelt]

Highlight all the cells, go to conditional formatting and put in the formula

=MOD(ROW($A1),5)=0

 

[WallyZ]

Thanks. Although your formula may be correct, David Biddulph's version is
more accurate.