Formatting Dynamic Range

RainmakerDNA

New Member
Joined
Sep 26, 2009
Messages
1
Is it possible to create a Dynamic Range
and have the formating apply to subsequent entries?

For example, I have regular dynamic range
percentages in column B, numbers in C, and accounting in D.

I would like to add new records and have them automatically
formatted without having to use format painter.

I would even consider using a macro.

Thanks
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

indiantrix

Well-known Member
Joined
Oct 17, 2002
Messages
943
Just guessing, however I believe a Table would do this for you. It would expand as needed, and if you first format each dolumn within the Table, the formatting will extend downward within each column as you add new rows of data to the table. HTH - Larry.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,662
Messages
5,573,484
Members
412,533
Latest member
Pejter
Top