Conditional Format #NUM!
 

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.

You could use

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

or simply

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

Regards,

Peo Sjoblom


"Charles" wrote:

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.