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

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

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

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

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