Conditional Formatiing
 

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

Thank you in advance.

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.

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.

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.

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.