ExcelBanter - Conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional formatting (https://www.excelbanter.com/excel-worksheet-functions/172580-conditional-formatting.html)

WallyZ

Conditional formatting

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

Dave Peterson

Conditional formatting

=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

WallyZ wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 01:09 PM.