You can catch an error, not so sure about the type

=ISERROR(A1)

--
HTH

Bob Phillips

"carl" wrote in message
...
Is it possible to use the conditional formatiing to identify #N/A (the
result
from a formula)

Thank you in advance.