Excel 2007 : Help inserting rows with correct formulas and conditional formatting

Hello,

I am looking for some assistance please with a resource planning spreadsheet I am currently developing (please find a reduced version attached).

Each row in the spreadsheet represents a new job. There are multiple columns for the user to insert information about the job (columns A:W). Columns X:CE are formula based as well as having conditional formatting behind them to control the cell colours.

To help ensure the correct formula and conditional formatting are always inserted between columns X:CE, I have created a macro (Macro8 - currently linked to the button at the bottom of the spreadsheet) which inserts a new row into row 4 and then inserts the correct formula and conditional formatting for that row. This then carries on as further new rows are added all the while maintaining the correct and consistent formulas and conditional formatting.

My issue is that the user now wants to be able to manually insert rows at any place in the spreadsheet. When this occurs, the formula does not copy down into the new row and the conditional formatting goes haywire for both the new row and the one it was inserted above.

I am thinking that my best course of action may be to create an InsertRow macro but am not really sure how to put it all together.

Any assistance would be greatly appreciated.

Many thanks in advance.

Hello, thanks for the quick reply! Each new row has to go all the way from column A to column CE.

Thanks again for any help you can provide.