Linking cells and cell color from another workbook

[oxicottin]

Hello, I have a question and wanted to know if it was possibe and if so how. I wanted to link cells from one workbook to another (Which I know how to do) the problem im having is the linking works but why doesnt the cell color chang like it is in the workbook im linking from? Example: If A1 has text (Me) with the cell being green then the linked workbook would only have the text (Me) and not the green cell. How would I do this?

Oh and there is no formula or code in the cells to change the colors its done manually.

Thanks,
Chad

 

[Trevor G]

Please don't double post your question it is against the forum rules.

 

[oxicottin]

Sorry friend i know the rules and im not trying to be a butt..... I didnt double post intentionaly what probibly happened was i used back button to fix post and submitted and it must have reposted my question.

Thanks