Formatting #N/A

[TomCat]

I have a graph in which I use NA() to skip plotting, but below the graph I
have to show the values. I tried conditional formatting to white out the
#N/A (ISNA(XXX) with no success. It whites out everything. Here's what I
need: IF there is a value, show it in the cell AND plot it. If the cell
value is #N/A, white it out and DON'T plot it.

Thanks.........TomCat

 

[Peo Sjoblom]

Try this, assume the cell in question is A1

then format>conditional formatting, formula is

=ISNA(A1)

then format white fonts

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[TomCat]

Got it......THANK YOU!

Try this, assume the cell in question is A1

then format>conditional formatting, formula is

=ISNA(A1)

then format white fonts

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon