Trap #Div/0 in conditional formatting

[Guest]

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

 

[Andy Brown]

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

 

[Guest]

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