thank you. if i wanted the conditional formatting to activate if the cell is
not eqaul to #N/A, is that possible ?

Thank you again.

"carl" wrote:

Is it possible to use the conditional formatiing to identify #N/A (the result
from a formula)

Thank you in advance.