Conditional Formating
 

Using conditional formatting, how can I blank a cell that has a formula that
doesn't return a value... eg #DIV/0!

Thanks

Click "Formula Is", and enter this:

=ISERR(A1)

And choose the format to be White font.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bassett" wrote in message
...
Using conditional formatting, how can I blank a cell that has a formula
that
doesn't return a value... eg #DIV/0!

Thanks