Well, having set up a number of financial/investment applications, I'd
be even more worried about leaving errors around on the worksheet,
especially if you're not the only user. But you *can* use conditional
formatting:

CF1: Formula is =ISERR(A1)
Format: Choose font color the same as the background



In article ,
Diane Alsing wrote:

I am doing a bunch of calculations on stocks, 20 days, 60 days, 90 days etc
of data - some stocks are IPOS & currently do not have 90 days of data - but
will in the future - so I don't want to mess with formulas etc - just want
the sheet to MASK the temporary lack of data. I am trying to se the IF(ISERR
function, but due to the impossibilty of using find/replace to add this to
all cells (link issures) I was hoping to use conditional formating. Perhaps
combining the IF(ISSERR function within conditional formating, but at this
point - have not figued out if/how to use this.