Conditional Formatiing

[Guest]

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

Thank you in advance.

 

[Domenic]

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!

 

[Bob Phillips]

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

=ISERROR(A1)

 

[Guest]

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.

 

[Domenic]

Change the formula to the following...

=(1-ISNA(A2))