Formatting Dynamic Range

[RainmakerDNA]

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

 

[indiantrix]

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.