Conditional formatting a cell with division of zero error #Div/0!

are there a lot of formulas
you could add an IFERROR or other error correction, BUT it will need to be done to ALL formulas that return #Div/0!
otherwise the conditional formatting is probably a quick solution - to test the cell for an Error & change the font to white for printing

depending on the formula in A1
but IFERROR( formula, "")

your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

I'm still not there in this situation, although I like the IF ERROR(formula,"") technique. My cell, let’s call it A1, needs to appear blank when there is a division by zero. In this cell there is a reference to another cell i.e. “=Z1.” I don’t want to touch cell Z1.

Not sure how I use the =Z1 with the IFERROR. I tried [IF ERROR(=Z1,"")].

assuming the formula is =B1/C1 in A1
then rather than a Div0 error you can use iferror like this
in A1 you replace =B1/C1 with
=IFERROR(B1/C1,"")

then in A1 put

=IFERROR(Z1,"")

your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.