Color formatting issues - I want zero formatting in cell containing text?

Hi all,

I have made a dummy file/sheet of larger sheet I've set up. Basically, I have a sheet with 'raw data' which is updated from another source with copy and paste. Linked to this sheet is another sheet which pulls data directly from the sheet with raw data.

Often, the raw data sheet might have empty cells.

Referencing an empty cell returns a zero in Excel in my linked sheet. This is not desirable. So, I have worked around this by using an IFERROR formula. The result is a blank cell also in the linked sheet. Nice.

The problem is however that my color formatting seems to include the blank cells also. I think my blank cell basically contains text. I've tried using various formula, but I can't make it to work. This is using the conditional formatting tools built in Excel.

Any advice?

Formatting.png