On May 20, 5:43*am, JBW wrote:
This is going to be easy peasy I know, but it's got me stumped.

I need to copy a cells contents and format (not conditional) into a
frontsheet.

Using simple =example!C1 the cell contents come over but not the colouring

Help please

Hi

Copy your cell, then in the destination cell right click, choose Paste-
Special,
select "Values" if that's waht you want or "Formulas" if you want to
retain the formula. No formatting will come across.

Regards,
Justin