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

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" <(E-Mail Removed)> wrote in message
news:349A5326-D36A-4A06-A7C7-(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in message
> news:349A5326-D36A-4A06-A7C7-(E-Mail Removed)...
> >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
>

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" <(E-Mail Removed)> wrote in message
> news:349A5326-D36A-4A06-A7C7-(E-Mail Removed)...
> >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
>

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" <(E-Mail Removed)> wrote in message
> news:349A5326-D36A-4A06-A7C7-(E-Mail Removed)...
> >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
>