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

Try this, assume the cell in question is A1

then formatconditional 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" wrote in message
...
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

Got it......THANK YOU!

"Peo Sjoblom" wrote:

Try this, assume the cell in question is A1

then formatconditional 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" wrote in message
...
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