Sofia wrote:
Challa,

I have been trying to reflect the change of color in llinked cells from on
sheet to another. The value changes but not color, do you know how to do
that. Do I have to make a macro?
Sofia

No.

[quoted text clipped - 56 lines]

JG


You will have to copy / paste your ranges
You may want to pastespecial values & formats.

I know it's a bind, but that's the way it is.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200705/1