Conditional Formatting on #VALUE!

J

JE

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

I cannot locate a command the executes properly.

Many thanks.
 
G

Glenn

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.
 
D

Dave Peterson

You could use
formula is:
=iserror(a1)
where A1 is the cell you want to check.
 
J

JE

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
 
L

Luke M

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

surathammaster

เมื่อ วันศุà¸à¸£à¹Œà¸—ี่ 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 เขียนว่า:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 3
Excel Highlighting duplicates 0
Excel conditional formatting with Weeknum 4
Excel Conditional Formatting Removal 7
Conditional Formatting 1
Conditional formatting on a dynamic range - workaround 1
Conditional Formatting for entire row 4
Conditional formating 1

Top