Formatting #N/A
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
|