Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatiing
Is it possible to use the conditional formatiing to identify #N/A (the result
from a formula) Thank you in advance. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
How do i create a conditional sum? | Excel Worksheet Functions | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |