S
sungen99
How do I make the background color of a1 be red if the value of v1 is
“#N/A”?
Thanks for your help.
Ken
“#N/A”?
Thanks for your help.
Ken
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.
P
Peo Sjoblom
Select A1, do format>conditional>formatting, formula is
=ISNA(V1)
click format button and select patterns, select red and click OK twice
=ISNA(V1)
click format button and select patterns, select red and click OK twice
S
sungen99
is there a code for ANY error?
S
sungen99
is there a code for ANY error?
S
sungen99
is there a code for ANY error?
S
sungen99
sorry.. bad bumps...
P
Pete
You could use ISERROR( ) instead of ISNA( )
Pete
Pete
H
Harlan Grove
sungen99 wrote...
If you mean all errors, use ISERROR. If you mean other than #N/A, use
ISERR. If you mean a particular error other than #N/A (actually this
could also be used for #N/A), e.g., #VALUE!, use
COUNT(1/(ERROR.TYPE(x)=3)) or COUNTIF(x,"#VALUE!").
....is there a code for ANY error?
If you mean all errors, use ISERROR. If you mean other than #N/A, use
ISERR. If you mean a particular error other than #N/A (actually this
could also be used for #N/A), e.g., #VALUE!, use
COUNT(1/(ERROR.TYPE(x)=3)) or COUNTIF(x,"#VALUE!").