Hi Dawn

Not really - formulas can't amend the formatting of the cell in which
they reside (other than in limited circumstances eg by Conditional
Formatting). You would need to copy and pastespecial the formats from
the target cells yourself, I'm afraid.

Best regards

Richard


Dawn101 wrote:

When linking cells only the formula/value is copying over, I also need the
formatting. Is this possible?