| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting on #VALUE!
Is it possible to use conditional formatting if a cell is #VALUE!
I cannot locate a command the executes properly. Many thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting on #VALUE!
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting on #VALUE!
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting on #VALUE!
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting on #VALUE!
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting on #VALUE!
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Hybrid Mode
