Conditional format: if formula result is #N/A then make text color white? How?

  • Thread starter Thread starter Keith R
  • Start date Start date
K

Keith R

I have a series of cells that I need to graph.
In order to avoid false zero values, I've used an if formula, similar to:
=if(isnumber(A2),A2,na())

now I'm going to be using this workbook with some non-computer people who
are easily confused by stuff they don't understand, such as a bunch of
cells with #N/A in them, so I want to use conditional formatting to set the
text color in those cells to white (same as background) when the value
shown in #N/A.

Unfortunately, I can't figure out what I should put in the conditional
formatting box to get this to work- cell value = ??
I've tried variations of na() and #N/A and =na and nothing seems to catch-
any suggestions?

Many thanks,
Keith R
 
Keith,

In the Conditional Formatting dialog, change "Cell Value Is" to
"Formula Is" and enter

=ISNA(A1)

where A1 is the appropriate cell. Then in the format dialog,
change the text color to white.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top