Conditional Formating

B

Bassett

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

Thanks
 
R

Ragdyer

Click "Formula Is", and enter this:

=ISERR(A1)

And choose the format to be White font.
 
Top