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.

"Brian" wrote in message
...
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.

Sorry, I don't understand your response? Not sure how to find the message?

"Alan" wrote:


"Brian" wrote in message
...
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.

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)


"Brian" wrote in message
...
Sorry, I don't understand your response? Not sure how to find the message?

"Alan" wrote:


"Brian" wrote in message
...
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.

I tried your suggestion, unfortunately did not work.

"Bob Phillips" wrote:

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)


"Brian" wrote in message
...
Sorry, I don't understand your response? Not sure how to find the message?

"Alan" wrote:


"Brian" wrote in message
...
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.

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)


"Brian" wrote in message
...
I tried your suggestion, unfortunately did not work.

"Bob Phillips" wrote:

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)


"Brian" wrote in message
...
Sorry, I don't understand your response? Not sure how to find the
message?

"Alan" wrote:


"Brian" wrote in message
...
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.