Divide by zero
1. select cell A1
2. Format Conditional formatting... Formula is =iserror(a1)
3. format with the color of the font matching the background color
4. Copy A1
5. Select the entire worksheet
5. Edit PasteSpecial Formats
The divide by zero message and other error messages will become "invisible"
--
Gary''s Student - gsnu200740
"D Huber" wrote:
I have hundreds of formulas on multiple spreadsheets and each has the
possibiltity of dividing by zero and creating an error in the cell. Is there
code or a function to eliminate all of the error messages in all cells
without having to change each cell's formula?
|