You will use the "Formula is" option. See Teethless mama's post for how to
write the formula.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JE" wrote:

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.