software

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: www.excelforum.com/member.php...oamp;userid=27688
View this thread: www.excelforum.com/showthread...hreadid=540590You could try paste special, this allows you to copy formats. Go to Edit and
select it from there, this then brings up a menu.

quot;tillytee1quot; wrote:

gt;
gt; Hi
gt;
gt; I've been trying to link cells from one workbook to another and but I'm
gt; having trouble getting the format to copy.
gt;
gt; I have conditional formatting on the original cells eg. If cell has no
gt; value entered, the cell is red. Once a value is entered, the background
gt; will revert to white.
gt;
gt; However once I copy and paste the link from a cell with NO value to
gt; another workbook, this conditional formatting does not copy over. It
gt; simply puts in a 0. If the original cell does have a value entered, it
gt; copies over fine.
gt;
gt; Can anyone help?
gt;
gt; ps the workbooks are not shared.
gt;
gt; Thanks
gt;
gt;
gt; --
gt; tillytee1
gt; ------------------------------------------------------------------------
gt; tillytee1's Profile: www.excelforum.com/member.php...oamp;userid=27688
gt; View this thread: www.excelforum.com/showthread...hreadid=540590
gt;
gt;


Yep I've been pasting special and then the link.

The weird thing is, I've managed to do it previously on a similar
workbook with last year's data and it worked! I think it is a default
formatting problem but just can't suss it!!--
tillytee1
------------------------------------------------------------------------
tillytee1's Profile: www.excelforum.com/member.php...oamp;userid=27688
View this thread: www.excelforum.com/showthread...hreadid=540590Formulas don't bring over the formatting (including conditional formatting).
You could apply format|conditional formatting to that cell with the link if you
wanted, though.

And if your formula looks like:
='C:\My Documents\excel\[book2.xls]Sheet1'!$A$1

You'll get a 0 if that sending cell is empty.

You can rewrite your formula to check:

=if('C:\My Documents\excel\[book2.xls]Sheet1'!$A$1=quot;quot;,quot;quot;,
'C:\My Documents\excel\[book2.xls]Sheet1'!$A$1)

(all in one cell)

It's the same thing you see in a simple formula like:
=A1
if A1 is empty, you'll see a 0.
=if(a1=quot;quot;,quot;quot;,a1)
would be the fix for that.tillytee1 wrote:
gt;
gt; Hi
gt;
gt; I've been trying to link cells from one workbook to another and but I'm
gt; having trouble getting the format to copy.
gt;
gt; I have conditional formatting on the original cells eg. If cell has no
gt; value entered, the cell is red. Once a value is entered, the background
gt; will revert to white.
gt;
gt; However once I copy and paste the link from a cell with NO value to
gt; another workbook, this conditional formatting does not copy over. It
gt; simply puts in a 0. If the original cell does have a value entered, it
gt; copies over fine.
gt;
gt; Can anyone help?
gt;
gt; ps the workbooks are not shared.
gt;
gt; Thanks
gt;
gt; --
gt; tillytee1
gt; ------------------------------------------------------------------------
gt; tillytee1's Profile: www.excelforum.com/member.php...oamp;userid=27688
gt; View this thread: www.excelforum.com/showthread...hreadid=540590

--

Dave Peterson


Thanks Dave, the 'if' function worked.--
tillytee1
------------------------------------------------------------------------
tillytee1's Profile: www.excelforum.com/member.php...oamp;userid=27688
View this thread: www.excelforum.com/showthread...hreadid=540590