anyone good at excell?

Formatting doesnt affect cell formulas if thats what you mean.
no, what i mean is, the formula for E20 is =(D20-A21-A22-A23-A24-A25-A26-A27-A28-A29-A30-A31)
the code to make it "disappear" with the white font is "cell value is equal to =(0-A21-A22-A23-A24-A25-A26-A27-A28-A29-A30-A31)"

the formula for E21 is =(D21-A22-A23-A24-A25-A26-A27-A28-A29-A30-A31)
and the code to hide that one is "cell value is equal to =(0-A22-A23-A24-A25-A26-A27-A28-A29-A30-A31)"

so each cell requires its own formula to hide it
at least, i think