How do I underline every fifth row in an Excel 2007 worksheet?
A akphidelt May 12, 2008 #2 Highlight all the cells, go to conditional formatting and put in the formula =MOD(ROW($A1),5)=0
W WallyZ May 12, 2008 #4 Thanks. Although your formula may be correct, David Biddulph's version is more accurate.
