Linking cells from different workbooks

Giganews Newsgroups
Subject: Linking cells from different workbooks
Posted by:  tillytee1 (
Date: Wed, 10 May 2006


I've been trying to link cells from one workbook to another and but I'm
having trouble getting the format to copy.

I have conditional formatting on the original cells eg. If cell has no
value entered, the cell is red. Once a value is entered, the background
will revert to white.

However once I copy and paste the link from a cell with NO value to
another workbook, this conditional formatting does not copy over. It
simply puts in a 0. If the original cell does have a value entered, it
copies over fine.

Can anyone help?

ps the workbooks are not shared.


tillytee1's Profile:
View this thread: