Just <copy A1 from worksheet A to A1 in worksheet B (to copy the
formatting, even if it is conditional formatting), and then enter:

='worksheet A'!A1

in A1 of worksheet B

Hope this helps.

Pete

On Mar 27, 1:29*pm, oldLearner57
wrote:
hi community

how am I to create a link where, example:

at worksheet A,

A1 is being formatted with 2 decimal places and is shaded "Blue"

at worksheet B,

also at A1, I wish to create a link so that this "A1" will also able to get
the shaded "Blue" color as well as the formatted 2 decimal places from
worksheet "A"

can this be done?

any guide much appreciated

thanks community for assistance render

:)

--
oldLearner57