bold every 5th line and number every 5th line

[travizwebb1]

Hello,

I'm using Excel 2007, I need a macro that will bold every 5th row and number 5th row, starting by number 1.

The numbering of every 5th row needs to start in B1. The bolding of every 5th row also needs to start in row 1

 

[Jonmo1]

Welcome to the board...

You may be better off using conditional formatting for this..
If you use a macro to do it, and then for any reason insert or delete row(s), then your pattern is off.

What version of Excel do you have?

 

[Jonmo1]

Try this...

In A1, or whatever column you want the numbering...

=IF(MOD(ROW(),5)=1,ROUNDUP(ROW()/5,0),"")
And fill it down as far as needed.


Then highlight your ENTIRE range that you want the formatting applied to..
Click Conditional Formatting
New Rule
Use a Formula

Put the formua
=MOD(ROW(),5)=1

Apply your bolding format
And apply - ok..


Hope that helps.

 

[Rick Rothstein]

Try this...

In A1, or whatever column you want the numbering...

=IF(MOD(ROW(),5)=1,ROUNDUP(ROW()/5,0),"")
And fill it down as far as needed.

I think you can simplify your formula a little to this...

=IF(MOD(ROW(),5)=1,(ROW()+4)/5,"")

 

[Jonmo1]

Yep....Habits...

The roundup is helpfull when you want the # shown in the intermediate cells as well..

A1:A5 = 1
A6:A10 = 2
A11:A16 = 3
etc..