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...o&userid=27688
View this thread: http://www.excelforum.com/showthread...hreadid=540590