Conditional Formatting on #VALUE!

  • Thread starter Thread starter JE
  • Start date Start date
J

JE

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

I cannot locate a command the executes properly.

Many thanks.
 
JE said:
Is it possible to use conditional formatting if a cell is #VALUE!

I cannot locate a command the executes properly.

Many thanks.
Click to expand...


Use ERROR.TYPE(yourcell)=3 in the conditional format.
 
You could use
formula is:
=iserror(a1)
where A1 is the cell you want to check.
 
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
 
You will use the "Formula is" option. See Teethless mama's post for how to
write the formula.
 
เมื่อ วันศุà¸à¸£à¹Œà¸—ี่ 6 à¸à¸¸à¸¡à¸ à¸²à¸žà¸±à¸™à¸˜à¹Œ ค.ศ. 2009, 22 นาฬิà¸à¸² 25 นาที 13 วินาที UTC+7, Luke M เขียนว่า:
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!*
Click to expand...

Thank very much !! all poster ....

เมื่อ วันศุà¸à¸£à¹Œà¸—ี่ 6 à¸à¸¸à¸¡à¸ à¸²à¸žà¸±à¸™à¸˜à¹Œ ค.ศ. 2009, 22 นาฬิà¸à¸² 25 นาที 13 วินาที UTC+7, Luke M เขียนว่า:
 
Back
Top