I want to hide #DIV/0

  • Thread starter Thread starter Looping through
  • Start date Start date
How do I conditionally format a cell that returns the above error?

LT
Click to expand...

For the conditional format formula, use:

=ERROR.TYPE(cell_reference)=2

and format the font color to be the same as the background color.
--ron
 
if you want that excel shows blank instead of #DIV/0

use

=if(iserror(yourfuncion),"",(yourfuncion))


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Looping through" escreveu:
 
Hi,

Conditionally format it to show what? Turn the cell red, change the font
color, format the cell so the error doesn't show? Do you want to do this
just for printing or do you want to do this until the cell has a non-error
value? Better way to handle this is to replace the error formula with an IF
test to trap the error.

1. In 2003 select the cell, here A1, choose Format, Conditional Formatting,
Formula is from the first drop down, and enter =ISERR(A1), click Format,
Font, Color, pick the color that matches the background, probably white.

2. Suppose the formula that caused the problem was =A2/B2, then in the cell
with the formula replace it with =IF(B2=0,"",A2/B2)
 
Back
Top