Cell glitching through worksheet

**iamdapro** · 01-22-2015, 06:56 PM

Hi Everyone,

I am having a weird graphical glitch appear on my workbook. On my "Homepage" worksheet, I have a formula that calculates the percentage of completion of the "Input" worksheet with a long formula as a percentage. There is also a conditional formatting on this cell to fill the cells a certain color when when it is at 0%, <100%, and 100% (Red, Yellow, and Green). This can be seen in the images below:

Cell that glitches on home page.PNG

Cell conditional formatting.PNG

Here is the formula that is in that cell that basically counts the blank cells vs the filled cells and outputs a percentage:

=IF(SUM(COUNTIF('Input Sheet'!B4,""),COUNTIF('Input Sheet'!B6:B11,""),COUNTIF('Input Sheet'!B13:B51,""),COUNTIF('Input Sheet'!B55:B58,""),COUNTIF('Input Sheet'!B60,""),COUNTIF('Input Sheet'!B73:B78,""),COUNTIF('Input Sheet'!B83,""),COUNTIF('Input Sheet'!B87,""),COUNTIF('Input Sheet'!B94:B102,""),COUNTIF('Input Sheet'!B105,""),COUNTIF('Input Sheet'!B108,""),COUNTIF('Input Sheet'!B114,""),COUNTIF('Input Sheet'!B121:B133,""),COUNTIF('Input Sheet'!E137:F142,""),COUNTIF('Input Sheet'!H137:J142,""),COUNTIF('Input Sheet'!L137:M142,""))=0,1,COUNTA(InputCells)/(COUNTA(InputCells)+(SUM(COUNTIF('Input Sheet'!B4,""),COUNTIF('Input Sheet'!B6:B11,""),COUNTIF('Input Sheet'!B13:B51,""),COUNTIF('Input Sheet'!B55:B58,""),COUNTIF('Input Sheet'!B60,""),COUNTIF('Input Sheet'!B73:B78,""),COUNTIF('Input Sheet'!B83,""),COUNTIF('Input Sheet'!B87,""),COUNTIF('Input Sheet'!B94:B102,""),COUNTIF('Input Sheet'!B105,""),COUNTIF('Input Sheet'!B108,""),COUNTIF('Input Sheet'!B114,""),COUNTIF('Input Sheet'!B121:B133,""),COUNTIF('Input Sheet'!E137:F142,""),COUNTIF('Input Sheet'!H137:J142,""),COUNTIF('Input Sheet'!L137:M142,"")))))

Now for the glitch. When I am on the "Input" worksheet, as I am filling in the values, the cell on the Homepage with this huge formula glitches through the Homepage to the Input worksheet as seen in the image below:

glitch.PNG

This glitchy cell goes away if I switch worksheets or just scroll down the page and then back up. It seems to be a graphical glitch that just appears as I fill in cells on the Input sheet and then goes away when it is 'refreshed' from the screen. It will appear multiple times when I am filling out the InputSheet and it appears randomly, not just from certain cells.

I have tried it on multiple computers with the same exact issue.

I am on Excel 2013.

I have tried removing the conditional formatting and it still shows this glitch randomly.

Due to the confidential content of the workbook, I cannot attach it.

Please let me know if there is any additional info that you may need about this.

Thank you in advance for any feedback!

EDIT 1: Could it be something about this cell having such a large formula that it is causing it to glitch through? Is this formula even that large?