Conditional formatting cells with formulas = "DIV/0!"

[Marcus Analyst]

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?

 

[Chip Pearson]

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]

Wow! Worked seamlessly! Thanks a lot Chip!

 

[Marcus Analyst]

Chip sorry to bother you again, but how would I conditionally format a cell
if the result of the formula is "VALUE!" ?

 

[Marcus Analyst]

Chip, I figured out the answer - it is a Type 3 error. Once again, thanks so
much for your help!