| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding error message
I have a cell that displays an error message #DIV/0! (divide by zero error).
How do I hide this error message? I tried Conditional Formatting: Formula Is =ISERROR (the cell that contains the zero). But I get an error message that reads "You may not use unions, intersections, or array constants for Conditional Formating criteria." The cell that contains the zero is on an adjacent worksheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding columns, error message says cannot shift objects off sheet | Excel Discussion (Misc queries) | |||
| Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
| Hiding zero values | Excel Worksheet Functions | |||
| Hiding rows before printing | Excel Discussion (Misc queries) | |||
| Hiding Personal.xls Requires Exit Twice | Excel Worksheet Functions | |||
Threaded Mode
