conditional formatting #value!

[Clive Long,UK]

Hi

Is it possible to create a conditional formatting condition that
can detect the condition of #VALUE! ? That is NOT the text string but
the "error condition". What I am trying to highlight is that certain
calculated values have not been correctly calculated on the sheet and
need further investigation.

Thanks

Clive

 

[Andy Pope]

Hi Clive,

Use the 'Formula Is' option on the conditional formating dialog and
enter the following, assuming the cells is A1.

=ERROR.TYPE(A1)=3

You can also use the Go To dialog (CTRL+G), Special... to locate cells
with Errors.

Cheers
Andy

 

[Dave Peterson]

If it's ok to cast a broader net, you could use a formula like:

=iserror(a1)