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