Linking cells from different workbooks

Giganews Newsgroups
Subject: Linking cells from different workbooks
Posted by:  tillytee1 (tillytee1.27l6mn_1147255801.7806@excelforum-nospam.com)
Date: Wed, 10 May 2006

Hi

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.

Thanks

--
tillytee1
------------------------------------------------------------------------
tillytee1's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=27688
View this thread:http://www.excelforum.com/showthread.php?threadid=540590

Replies