Mick

Either trap for the error as KL shows or if you want to use CF.......

Select the cell or cells to CF

CFFormula is: =ISNA(cellref) Remove $ signs if Excel sticks them in
cellref.

FormatFontColorWhite

OK your way out.

Gord Dibben Excel MVP

On Tue, 30 Nov 2004 09:09:13 -0000, "Mick" wrote:

Can anyone help please with how to hide #N/A please?

I have tried conditional formatting but cant get the settings right.