Formatting to hide the errors
Posted by Dominic on June 07, 2001 7:19 AM
If I have a large table referencing various cells , i include the following if if(a1="","",a1/a2) to prevent the error of div0 etc.
How can I apply a conditional formatting that says if error then cell empty? or locked
Posted by Mark W. on June 07, 2001 7:37 AM
Dominic, your formula below won't prevent a #DIV/0!
error. Use =IF(A2,A1/A2,"") and you won't need a
conditional format.
Posted by RayH on June 29, 2001 3:06 PM
In conditional formatting, choose Formula Is and use =iserror(cellref) and under formatting make the font the same color as the background (most cases is white).
