Conditional format for #DIV/0

  • Thread starter Thread starter TMF in MN
  • Start date Start date
T

TMF in MN

Is it possible to setup a conditional format based on a formula result? If
the formula returns a non-numeric value... like that standard #DIV/0, can
that be formatted?

If so, how?
 
Try this...

A1 = some formula

Select cell A1
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=ISERROR(A1)
Click the Format button
Select the desired style(s)
OK out
 
Back
Top