Established spreadsheet shows err for errors for div/0
 

Chris

You can use conditional formatting with a formula like

=ISERROR(A1)

and set the forecolor to white (assuming your backcolor is white). Then
copy that formatting to all the other cells.

It's a little dangerous though when you have errors and don't see them, so
use it wisely.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Chris Sergent" wrote in message
...
I am so novice at programming in MS Excel.

However,
I have an Excel spreadsheet with a great deal of formulas
on it. Is there a way to either globally suppress errors
on an Excel spreadsheet. If not, what code could be
written to check the current spreadsheet for any cells
that produce an error, to show up as "" without actually
changing the formula that already exists. Because all of
the formulas are different, a find and replace will not
work.

I appreciate any help. Thanks.

Chris