To apply same formula or format to new raw after the row that contains the formula you must enable "Extend data ranges formats and formula" in excel. To enable this function do following.
- Click on Office Button (1) in Excel. Now click on Excel Options (2).
- In Excel Options click on Advance.
- In right-pane Check the checkbox "Extend data range formats and formulas" and Click on "Ok".
With help of Microsoft office website.
