Macro that creates new column

[ciapul12]

I need a macro that will create new column, copy only formulas and conditional formatting from the last column and paste it into the new column is this possible at all???
Thanks for help
Dan

[Excel Fox]

Yes, very much possible. But since the conditional format, and formulas could work differently depending on its referencing, it will be better if you post a sample file that resembles the scenario / situation in your original file.