Trap #Div/0 in conditional formatting
 

is it possible to detect the #Div/0! text / error in conditional formatting,
so that if it appears, due to empty cells else where in the sheet, I can set
the font colour to the same as the background colour to hide it?
I tried using an 'If' statement to detect empty cells, then not using the
formula if any were empty, but my users need to edit the formula to suit
their needs, and don't have the knowledge to use the 'If' statement.

Any help appreciatted.
Thanks

Neil

is it possible to detect the #Div/0! text / error in conditional
formatting,

How about

=ISERROR(C1)

, where C1 is the #DIV/0! cell.

HTH,
Andy

Hi
in the conditional format dialog enter
=ISERROR(cell_reference)
to check for an error condition

"Neil" wrote:

is it possible to detect the #Div/0! text / error in conditional formatting,
so that if it appears, due to empty cells else where in the sheet, I can set
the font colour to the same as the background colour to hide it?
I tried using an 'If' statement to detect empty cells, then not using the
formula if any were empty, but my users need to edit the formula to suit
their needs, and don't have the knowledge to use the 'If' statement.

Any help appreciatted.
Thanks

Neil