How can I globally set "error message" parameters in Excel

[Guest]

I get error messages on many (if not most) of my spredsheet cells. Almost
all of them are unimportant or just plain nonsense. I can fix cell by cell,
but that takes forever and should not be necessary. How can I globally get
rid of this maddening nonsense?

 

[Jezebel]

Correct the formulas.

 

[Max]

One way to achieve a clean visual, without plunging into error-trapping
individual formulae which are returning the error msgs, is to use
conditional formatting to mask the appearance

Try this:

Select A1, then press CTRL+A
Click Format > Cond Formatting
Under condition1, make the settings:
Formula is: =ISERROR(A1)
Click Format button > Font tab > Font color white* > OK
Click OK at the main dialog

*assumes the cells' fill color is either white or the default "no color"

 

[Biff]

Hi!

Are you talking about those stupid colored triangles?

If so, goto Tools>Options>Error Checking>Rules

Uncheck everything listed!

Biff

 

[Max]

I'm glad I don't have this problem in xl97 <bg>

 

[Guest]

Thanks,

I have been doing that cell-by-cell, but want to be able to "clear" a new
spredsheet before starting so that I don't run into the problem later. Thus
teh request for a "global" (not cell-by-cell) solution.

Any other ideas?

Thanks