Use format>conditional formatting, select the cells and use formula is

=ISNA(A1)

now click the format button, select fonts and a white font that is not
visible

You said that you already tried that but what didn't work? You can also hide
the range altogether


--
Regards,

Peo Sjoblom

(No private emails please)


"bartinpc" <bartinpc.1qiwia_1118595900.4028@excelforum-nospam.com> wrote in
message news:bartinpc.1qiwia_1118595900.4028@excelforum-nospam.com...
>
> From what I understand, Conditional Formatting will only formats
> constants in the cells. Is there a way to format the results of an
> expression?
>
> I am having a column calculate a running average, and then graph it on
> a separate sheet. I am using the NA() function to get the graph to
> only show the non-zero results. That works great for the graph. I
> would like though to not have the #N/A show up on the numerical page.
> I have tried formatting it to the same color as the background with no
> luck.
>
> How would I go about this? Thanks for your help in advance.
>
>
> --
> bartinpc
> ------------------------------------------------------------------------
> bartinpc's Profile:
> http://www.excelforum.com/member.php...o&userid=20174
> View this thread: http://www.excelforum.com/showthread...hreadid=378402
>