Copying column with conditional formating VBA

[Olavfinnerud]

Hi, I have made a sheet to check results from a water test against a limit. I started with one column where you insert the results from the test. And if the result is higher than the value written under Grenseverdier Bærum Kommune then the cell becomes red, if its under the cell becomes green, and if it is equal the cell becomes green. I then added a button to insert a new column when you need to enter the results from a new test. The problem i have is when i insert a new column the conditional formating in the cells chances. Originally i have three conditions for each cell. One over, one under and one equal. When i add a new column multiple conditions gets added. I need help to get the same formatting for each column that i add. I have attached a picture of the spreadsheet and also the code i use to insert a new column.

I would really appreciate it if somebody could help me out! Thank you.

 

[rollis13]

Probably there was something wrong in the CF of your original column. Normally when you insert a new column you should always find 3 CF in the original column and 3 CF in the new column, the only difference you should see is that they refer to a different range. This difference will update in every column every time you insert a new column but you will always have only 3 CF.