Conditional formatting
How do I underline every fifth row in an Excel 2007 worksheet?
|
Conditional formatting
Highlight all the cells, go to conditional formatting and put in the formula
=MOD(ROW($A1),5)=0 "WallyZ" wrote: How do I underline every fifth row in an Excel 2007 worksheet? |
Conditional formatting
CF/ Formula Is/ =MOD(ROW(),5)=0/ Format with lower border.
-- David Biddulph "WallyZ" wrote in message ... How do I underline every fifth row in an Excel 2007 worksheet? |
Conditional formatting
Thanks. Although your formula may be correct, David Biddulph's version is
more accurate. "akphidelt" wrote: Highlight all the cells, go to conditional formatting and put in the formula =MOD(ROW($A1),5)=0 "WallyZ" wrote: How do I underline every fifth row in an Excel 2007 worksheet? |
All times are GMT +1. The time now is 04:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com