Hiding Expression Results...

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.

Conditional formatting will work with formulas.

If you want to hide N/A have you looked at the ISNA function?

I completely missed that function when going through the various help ideas.

It worked like a charm. Thank you very much.

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>