The cell that contains the zero is on an adjacent worksheet.

Change the formula to test for 0. Since you didn't post your formula try to
adapt this to it:

=IF(Sheet2!A1=0,"",B1/Sheet2!A1)

Biff

"Mark Flynn" wrote in 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.