| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#N/A
You can explicitly address the #!N/A using the FormulaIs option in
conditional formatting and use ISNA or ISERROR in the formula -- Gary''s Student - gsnu200908 "Doug" wrote: Some of my cells have #N/A in them because one of the required lookups in missing in some rows. The problem I am having is when I try to set up Conditional Formatting for the values in that column. It will not work if the selected range runs over top of that #N/A value. Is there a way around this problem? I would just a soon that it overlook the #N/A value. -- Thank you! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#N/A
What would the formula look like if I am wanting all values 0 to have a
green arrow up? -- Thank you! "Gary''s Student" wrote: You can explicitly address the #!N/A using the FormulaIs option in conditional formatting and use ISNA or ISERROR in the formula -- Gary''s Student - gsnu200908 "Doug" wrote: Some of my cells have #N/A in them because one of the required lookups in missing in some rows. The problem I am having is when I try to set up Conditional Formatting for the values in that column. It will not work if the selected range runs over top of that #N/A value. Is there a way around this problem? I would just a soon that it overlook the #N/A value. -- Thank you! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#N/A
I tried this and it says there is an error. Do you see one?
=IF(ISERROR(VLOOKUP($S3,Import!$P:$CB,17,FALSE)/(VLOOKUP($S3,'Old Import'!$P:$CB,17,FALSE))))-1 -- Thank you! "Gary''s Student" wrote: You can explicitly address the #!N/A using the FormulaIs option in conditional formatting and use ISNA or ISERROR in the formula -- Gary''s Student - gsnu200908 "Doug" wrote: Some of my cells have #N/A in them because one of the required lookups in missing in some rows. The problem I am having is when I try to set up Conditional Formatting for the values in that column. It will not work if the selected range runs over top of that #N/A value. Is there a way around this problem? I would just a soon that it overlook the #N/A value. -- Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
