C
carl
Is it possible to use the conditional formatiing to identify #N/A (the result
from a formula)
Thank you in advance.
from a formula)
Thank you in advance.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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!
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!
B
Bob Phillips
You can catch an error, not so sure about the type
=ISERROR(A1)
=ISERROR(A1)
C
carl
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.
not eqaul to #N/A, is that possible ?
Thank you again.
D
Domenic
Change the formula to the following...
=(1-ISNA(A2))
=(1-ISNA(A2))