how to hide error messages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been working on a sheet that works with days of the
month. some months have more days then others (of course)
and leaves some cells with errors when there are fewer
then the 31 days.

My question is that I dont care that there is an error but
I would like to hide the error message (#value!) so it
does not show up.

I have looked in the help section and it mentions to use
conditional formating and =ISERROR(reference). I have
followed these instructions many times and still have the
error showing. I have cut and pasted what it says in the
help section. When it metions 'type' I assume that this is
not included into the box. Also do u need to put brackets
around the reference? If some one has an example of what
they got to work that would be great.

"Select the cells that contain the error value.
On the Format menu, click Conditional Formatting.
In the box on the left, click Formula Is.

In the box on the right, type =ISERROR(reference), where
reference is a reference to the cell that contains the
error value.
Click Format, and then click the Font tab.

Click Format.
In the Color box, select white."


Thanks
Blaster
 
Hi
if your which shows the error is A1 try the following
- select cell A1
- goto the conditional format dialog and enter the following formula:
=ISERROR(A1)
- now choose your format

you may also use a formula directly in your worksheet. Something like
the following in A1
=IF(ISERROR(your_existing_formula),"",your_existing_formula)
 
That did it. I tried both ways and they both worked.

Thanks for your help AGAIN!

Blaster
 
Back
Top