Conditional format to hide #N/A

  • Thread starter Thread starter Ann Scharpf
  • Start date Start date
A

Ann Scharpf

I have set up a spreadsheet to use Jon Peltier's REALLY
helpful pointers on setting up conditional formatting in a
chart. ("Simple Conditional Charts" on
http://www.geocities.com/jonpeltier/Excel/Charts/format.htm
l.)

Using this method, I have a LOT of cells with the #N/A
error in them (as I am supposed to). At home, I have
Excel XP which has an option for blanking out #N/A on
hardcopy prints. At work, my Excel 2000 does not seem to
have this option.

But, ideally, I'd like to have the cells conditionally
formatted with font color = white when the error comes
up. I have tried to use conditional formatting with
Formula / =Error.Type=7
Cell is / equal to / Error.Type=7

(Error type 7 equates to #N/A.)

Is there any way to check for an error condition and apply
conditional formatting?

TIA

Ann Scharpf
 
I figured it out myself. I used the Conditional Format:
Formula is / =IF(ERROR.TYPE(B44)=7,"true","false")
 
Ann

This formula in conditional formatting

=ISERROR(A2)

will catch all errors.


--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.
 
Ann,

One way:
For #N/A in cell A1 for example, cond format /formula is
=isna(A1). Then add your formatting preferences. You might
find that the formula changes to=isna($A$1) after first
use, in which case change it back. You can then cop
relative to other cells

David
 
Back
Top