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 เขียนว่า:
 
You must log in or register to reply here.

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 1
Conditional Formatting 3
Excel Macro to automatically go to the right of the last colored cell 0
Excel conditional formatting with Weeknum 4
Excel Highlighting duplicates 0
Can one change shape properties conditionally? 1
Conditional Format Won't Update Cell 8
Conditional format a column based on value in a different column 3

Back
Top