Conditional formatting errors

[markstro]

I routinely conditionally format cells "cells equals zero" to format zero's the same color as cell background to hide them, is there any way to format for "#div/0!" the same way when I don't have all the data to return a valid dividend???

 

[jim may]

Use FormulaIs =ISERROR($E$3) << In Text Box

 

[Scott Huish]

Sure, but I would first suggest to fix the formula.

i.e.

=IF(B1,A1/B1,"")

Assuming Column A, use the following conditional formatting formula:

=ERROR.TYPE($A1)=2

 

[markstro]

Thanks guys, just what I needed, been wondering about that for awhile.