Thank you for the response. I am applying conditional formatting to the cell
with #VALUE!.

In Condition box, should I select "Cell Value Is" or "Formula Is". Also,
will I need to reference the cell (as I am applying that formatting to the
cell)?

Apologies for not including this previously.

Regards

"Glenn" wrote:

JE wrote:
Is it possible to use conditional formatting if a cell is #VALUE!

I cannot locate a command the executes properly.

Many thanks.


Use ERROR.TYPE(yourcell)=3 in the conditional format.