hi Kazuki,

we can give the like it will work well, but we can't format the linked cell
its not possible linked cell cannot be possible... if there is no link u
can get the same format which is u copy and paste options....

but in this case its impossible ok

reply pls
--
Name : K.Prasad
Inventory Manager
CRYSTALGALLERY
DUBAI



"Kazuki" wrote:

Hi,
I have a work sheet in which I copy dates from many other individual's work
sheets. I have linked these cells. But the individual work sheets have color
coded dates. These formats(color) are not appearing while linking.
Is there a way around? I cannot copy-paste the original contents because
this needs to be done every week for many individuals!
Thanks.