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?

Correct the formulas.



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

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"

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Evansct" wrote in message
...
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?

Hi!

Are you talking about those stupid colored triangles?

If so, goto ToolsOptionsError CheckingRules

Uncheck everything listed!

Biff

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

I'm glad I don't have this problem in xl97 <bg
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Biff" wrote in message
...
Hi!

Are you talking about those stupid colored triangles?

If so, goto ToolsOptionsError CheckingRules

Uncheck everything listed!

Biff

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

"Biff" wrote:

Hi!

Are you talking about those stupid colored triangles?

If so, goto ToolsOptionsError CheckingRules

Uncheck everything listed!

Biff

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