Hiding #N/A

M

Mick

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

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

Mick

Thanks "KL"

I'm sorry I must be missing something.

I have tried entering your suggestion in both conditional formatting and
directly in a cell using "My Formula" and neither seem to work (most likely
me at fault).

Can you help further please?

Regards

Mick
 
K

KL

Mick,

If for example your formula that returns #NA! is
=VLOOKUP(A1,$B$1:$D$10,2,FALSE), then do this

=IF(ISNA(VLOOKUP(A1,$B$1:$D$10,2,FALSE)),"",VLOOKUP(A1,$B$1:$D$10,2,FALSE))

Regards,
KL
 
G

Gord Dibben

Mick

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

Select the cell or cells to CF

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

Format>Font>Color>White

OK your way out.

Gord Dibben Excel MVP
 
Top