The value and the display are 2 different things. If it references an empty
cell its VALUE is zero. You can format the cell to not display the zero,
though it will still have a zero value. The other option - to show "" -
you've already dismissed.

Maybe your best bet is to adjust your conditional formatting logic

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