Hi JE,

this is exactly what I cant do, when I set the cell on worksheet2 to "" it
mucks up the conditional formatting, turning the cell green when it should be
white (ie no conditional formatting because its a null cell)
Im really confused as to why the cell appears empty on 1 sheet and 0 on the
other, when there is no apparent differences in the display format 9both set
to general)
any ideas?
thanks!

"JE McGimpsey" wrote:

A formula can't return a null/empty result.

You can, of course, use

=IF(Sheet1!A1="","",Sheet1!A1)

I'm not sure why you can't use a null string ("") with Conditional
Formatting...

In article ,
dee wrote:

Hi,
I have a cell in worksheet2 which references a cell in worksheet 1:
e.g = Worksheet1!A3
But if A3 in woksheet 1 is empty (null?) the cell in worksheet2 has a 0 in it.
Is there any way to get the cell in worksheet2 to also show null?
i need it to show null and not "" because of conditonal formatting I have
thanks!!!