Conditional Format #NUM!

[Charles]

Hello-

I have a formula that will result in #NUM! when data is
missing from its source cell. Is there a way to
conditionally format the #NUM! cell? I'm not sure what
the cell equals when it reads #NUM!.

Thanks in advance.

 

[Peo Sjoblom]

You could use

=IF(source_cell="","",your_formula))

or simply

=IF(ISERROR(your_formula),"",your_formula)

Regards,

Peo Sjoblom