Thread: Formatting #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomCat
 
Posts: n/a
Default 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