Hiding Expression Results...

  • Thread starter Thread starter bartinpc
  • Start date Start date
B

bartinpc

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?
 
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)
 
I completely missed that function when going through the various help
ideas.

It worked like a charm. Thank you very much.
 
Back
Top