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
|