Hide #VALUE!

[norm01]

I have =L3-M3 (L4-M4,etc) with #VALUE! showing when one cell has no value
I need the values showing in the other cells when both cells have a value but dont want to see #VALUE!
I have tried conditional formatting to turn the font white and have looked through this site for an answer can someone help?

[Ace_XL]

Use this formula instead

For 2003 and earlier versions of Excel
=IF(ISERROR(L3-M3),"",L3-M3)

For later versions
=IFERROR(L3-M3,"")

[norm01]

Success,
Thank you for your help