Use the Formula Is option in conditional formatting and use this formula:

=ISNA(cell_reference)

Replace cell_reference with the actual cell reference.

--
Biff
Microsoft Excel MVP


"LinLin" wrote in message
...
Hi Everyone

I would like to use Conditional Formatting to highlight for me when #N/A
is
the result of a formula.

(I have used Conditional Formatting before for number values, but this has
me stumped!)

Many thanks!