Conditional Formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Conditional Formatting for #DIV/0! 6
Conditional Formatting with Calculated Blank 2
Conditional Format Excel 2007 6
Conditional Format & Default Format Help 1
Excel VBA 1
#N/A Conditional Formatting affects all cells? 9
conditional formatting 1

Back
Top