Hi Crizzle,

Why don't you just copy all of column 'a' in sheet 1 and paste into column 'a' in the other sheet, this will copy the formulas and conditional formatting