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!!!