Conditional format for #DIV/0

[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?

 

[T. Valko]

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

 

[Mike H]

Hi,

=iserror(a1)

would work as a CF formula

Mike