software

How do I make the background color of a1 be red if the value of v1 is
“#N/A”?

Thanks for your help.
Ken--
sungen99
------------------------------------------------------------------------
sungen99's Profile: www.excelforum.com/member.php...foamp;userid=9144
View this thread: www.excelforum.com/showthread...hreadid=497583Select A1, do formatgt;conditionalgt;formatting, formula is

=ISNA(V1)

click format button and select patterns, select red and click OK twice--

Regards,

Peo Sjoblom

quot;sungen99quot; gt; wrote in
message ...
gt;
gt; How do I make the background color of a1 be red if the value of v1 is
gt; quot;#N/Aquot;?
gt;
gt; Thanks for your help.
gt; Ken
gt;
gt;
gt; --
gt; sungen99
gt; ------------------------------------------------------------------------
gt; sungen99's Profile:
www.excelforum.com/member.php...foamp;userid=9144
gt; View this thread: www.excelforum.com/showthread...hreadid=497583
gt;

is there a code for ANY error?--
sungen99
------------------------------------------------------------------------
sungen99's Profile: www.excelforum.com/member.php...foamp;userid=9144
View this thread: www.excelforum.com/showthread...hreadid=497583
is there a code for ANY error?--
sungen99
------------------------------------------------------------------------
sungen99's Profile: www.excelforum.com/member.php...foamp;userid=9144
View this thread: www.excelforum.com/showthread...hreadid=497583
is there a code for ANY error?--
sungen99
------------------------------------------------------------------------
sungen99's Profile: www.excelforum.com/member.php...foamp;userid=9144
View this thread: www.excelforum.com/showthread...hreadid=497583
sorry.. bad bumps...--
sungen99
------------------------------------------------------------------------
sungen99's Profile: www.excelforum.com/member.php...foamp;userid=9144
View this thread: www.excelforum.com/showthread...hreadid=497583You could use ISERROR( ) instead of ISNA( )

Petesungen99 wrote...
gt;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,quot;#VALUE!quot;).