Hi
I have a work book where on sheet 1 I have a lot of data where I have highlighted different cel with text in different colours, On sheet 2 I have set for certain colums from sheet 1 to copy across using the generic ='sheet1A1' function,
I also want the cel colour to transfer with this but...