| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting cells with formulas = "DIV/0!"
I want to conditionally format a cell that 1) contains a formula and 2) the
result of the formula equals €œDIV/0!€ Is there a way to do this? -- Marc |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formatting cells with formulas = "DIV/0!"
In the Conditional Formatting dialog (from the Format menu), change "Cell
Value Is" to "Formula Is" and enter the following formula: =IF(ISERROR(A1),ERROR.TYPE(A1)=2) Of course, change the A1 reference to the appropriate cell. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Marcus Analyst" wrote in message ... I want to conditionally format a cell that 1) contains a formula and 2) the result of the formula equals €œDIV/0!€ Is there a way to do this? -- Marc |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formatting cells with formulas = "DIV/0!"
Wow! Worked seamlessly! Thanks a lot Chip!
-- Marc "Chip Pearson" wrote: In the Conditional Formatting dialog (from the Format menu), change "Cell Value Is" to "Formula Is" and enter the following formula: =IF(ISERROR(A1),ERROR.TYPE(A1)=2) Of course, change the A1 reference to the appropriate cell. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Marcus Analyst" wrote in message ... I want to conditionally format a cell that 1) contains a formula and 2) the result of the formula equals €œDIV/0!€ Is there a way to do this? -- Marc |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formatting cells with formulas = "DIV/0!"
Chip sorry to bother you again, but how would I conditionally format a cell
if the result of the formula is "VALUE!" ? -- Marc "Chip Pearson" wrote: In the Conditional Formatting dialog (from the Format menu), change "Cell Value Is" to "Formula Is" and enter the following formula: =IF(ISERROR(A1),ERROR.TYPE(A1)=2) Of course, change the A1 reference to the appropriate cell. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Marcus Analyst" wrote in message ... I want to conditionally format a cell that 1) contains a formula and 2) the result of the formula equals €œDIV/0!€ Is there a way to do this? -- Marc |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formatting cells with formulas = "DIV/0!"
Chip, I figured out the answer - it is a Type 3 error. Once again, thanks so
much for your help! -- Marc "Chip Pearson" wrote: In the Conditional Formatting dialog (from the Format menu), change "Cell Value Is" to "Formula Is" and enter the following formula: =IF(ISERROR(A1),ERROR.TYPE(A1)=2) Of course, change the A1 reference to the appropriate cell. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Marcus Analyst" wrote in message ... I want to conditionally format a cell that 1) contains a formula and 2) the result of the formula equals €œDIV/0!€ Is there a way to do this? -- Marc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - find cells containg "+" | Excel Discussion (Misc queries) | |||
| Excel 2003: Conditional Formatting using "MIN" & "MAX" function | Excel Discussion (Misc queries) | |||
| Conditional formatting cells with formulas = "#VALUE!" | Excel Discussion (Misc queries) | |||
| Using conditional formatting to "blank" cells | Excel Discussion (Misc queries) | |||
| excel should "paste special" a "conditional formatting" | Excel Programming | |||
Linear Mode
