hide "#VALUE!"

B

Brian

My worksheet is linked to a web query and the value of many cells is
"#VALUE!". The message is "value used in formula is wrong data type". Due to
the nature of the web query, I can live with this without making changes
however I would simply like to "hide" or show a blank cell if the cell shows
this message. I apprectiate suggestions to do this. Thank you.
 
A

Alan

Brian said:
My worksheet is linked to a web query and the value of many cells is
"#VALUE!". The message is "value used in formula is wrong data type". Due
to
the nature of the web query, I can live with this without making changes
however I would simply like to "hide" or show a blank cell if the cell
shows
this message. I apprectiate suggestions to do this. Thank you.
Click to expand...
 
B

Bob Phillips

Try using conditional formatting with a formula of =ISERROR(A1) and a font
colour of white.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

Did you select al the cells, change the condition type to Formula Is, and
the formula to the first cell in your selection?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Brian

Yes, I believe I have done all of that. Perhaps the problem is that I don't
have a formula in the cells, it is an msn stock quote web query. Maybe the
conditional format does not recognize that?

Just to confirm, my worksheet has linked values in cells a1:g50. In column
D, I would like to hide all "#VALUE!" messages. I have selected all cells in
column d and set conditional format to "formula is", =iserror(a1), and font
color to white. This is still not working. Thanks again.
 
B

Bob Phillips

No, if it is column D you want to hide, set the formula to =ISERROR(D1),
assuming D1 is the first cell in your selection.

The fact that it is formulas doesn't matter.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
F

Forrest

I have tried this and have only one problem - some of the cells in the row do
not return an error. When I applied this conditional formatting to the cells
without errors, the text in these cells disappeared as well. How do I get
this to applu on a cell by cell basis.

Thanks.
 
Top