I have a web programme (over which I have no control) which outputs data to
an excel spreadsheet.

Some cells appear empty and I want to highlight them using conditional
formatting. However, when I use the ISBLANK function, it transpires that the
apparently empty cells do have something in them, even though I cannot
identify what it is. The cells appear blank when you select each cell -
however, when I press delete and enter, something is clearly being removed
as the conditional formatting then shows the cells as empty. I hope this
makes sense.

Has anyone else every encountered this situation please?

Is there a way of getting round this either by using a function which will
clear the apparently empty cells, or another function I can use with
conditional formatting to identify the so called empty cells.

Thanks,

V