[JE]

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

I cannot locate a command the executes properly.

Many thanks.

[Glenn]

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.

[Teethless mama]

Conditional Formatting

=ERROR.TYPE($A1)=3


"JE" wrote:

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

I cannot locate a command the executes properly.

Many thanks.

[Dave Peterson]

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

JE wrote:

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

I cannot locate a command the executes properly.

Many thanks.

--

Dave Peterson

[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

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

[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!*


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

[[email protected]]

เมื่à¸* วันศุà¸�ร์ที่ 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!*


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


Thank very much !! all poster ....

เมื่à¸* วันศุà¸�ร์ที่ 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!*


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