Detecting a paste of data that breaks the current color scheme and repairing color scheme

Hi Guys,

The thing I am wanting to do is much easier to explain with an example, please download the attachment and have a look.

If you paste in a large chunk of data into the sheet, the document looks a complete mess and it breaks the color scheme, doesn't fix the formulas in N to O nor does it fix the border.
If you paste say 4 lines of data into the sheet the document gets confused and again doesn't look very good, you'll have a messed up sheet in terms of color, formula and just general appearance.

A copy of the color scheme, is avaliable in a hidden row 2 and a copy of the formula is avaliable in N and O on row 2 aswell.

An example of how to apply the formula is in the current macro that runs

An example of how to apply the color scheme from row 2 would be something like: Range("A2:T2").Copy: Range("A3:T" & LastRow).PasteSpecial xlPasteFormats

Please see the attachment for a MUCH clearer example

Thanks in advance