Try the following...

1) Select/highlight a cell within your data, let's say A1

2) Format Conditional Formatting Formula Is

3) Enter the following formula:

=ISNA(A1)

4) Choose your formatting

5) Click Ok

6) Copy to other cells using the 'Format Painter' or 'Copy Paste
Special Formats'

Hope this helps!

In article ,
"carl" wrote:

Is it possible to use the conditional formatiing to identify #N/A (the result
from a formula)

Thank you in advance.