Change the formula to the following...

=(1-ISNA(A2))

In article ,
"carl" wrote:

thank you. if i wanted the conditional formatting to activate if the cell is
not eqaul to #N/A, is that possible ?

Thank you again.

"carl" wrote:

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

Thank you in advance.