Conditional Formatting on #VALUE!
เมื่* วันศุกร์ที่ 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.
|