Help Adding a new row using excel macros

[vjk1234]

Hi,

I am new with macros and wanted some help on exploring whether something was possible. I have a table with 5 rows and 5 columns. However, every week based on certain inputs the number of rows can increase. What I wanted to do was, as soon as the i start entering information into a new row (in this example row 6) I want this entire row (till column 5 in the example) to have the same formatting and borders as the previous row. In my example here, all rows/columns have a border and row 1 is center justified.

Is this possible to do?

Thanks in advance....

[protonLeah]

Use Conditional Formatting:
Select all five columns A - E and use: =$A1<>""
and format for the desired border