Ask Your Question

Revision history [back]

Hello @Kagiso, I removed all the conditional formatting and the file went back up and running. except the k12 cell with the wrong formula, which I copied from K11 and pasted into k12, worked.

On the Div / 0 errors use the formula: =IFERROR(your formula;"")

Review the need for Conditional formatting.

-----------------------------------------------------------------------------

ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

Hello @Kagiso, I removed all the conditional formatting and the file went back up and running. except the k12 cell with the wrong formula, which I copied from K11 and pasted into k12, worked.

On the Div / 0 errors use the formula: =IFERROR(your formula;"")

Review the need for Conditional formatting.

Here is the file with the conditional formatting excluded from the worksheets 10K1 and 11K3 and in 10K1 I used the IFERROR formula.

-----------------------------------------------------------------------------

ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question. question.