Disappearing Cells Issue (Possibly Related to Conditional Formatting)

[sk8blitz23]

My excel is experiencing an issue where various adjustments to the excel (data entered into cells, resizing columns/rows, etc.) causes some of the excel cells to "disappear", usually a few rows that are all grouped together. When I say "disappear", I mean that the text displayed in the cells disappear, and the borders around those cells disappear. The background color remains. See my screenshots in the attached word document (Figure 1 is how it should normally look, and figure 2 is with the "disappeared" rows). Sometimes, the disappeared cells will come back and stay back when I adjust the row height of the affected rows, but sometimes this will make the disappeared cells return for just a second, only to disappear immediately again. Sometimes scrolling to the top of the worksheet and back down will make the cells re-appear again. It seems hit or miss as to what will temporarily fix the problem, but I don't have a permanent fix.

In the particular instance of the screenshots, the disappearance was caused by entering the letter X in cell K187 (i.e. a cell that was unrelated to the disappeared cells).

My hunch is that the issue stems to conditional formatting, since in the past I had re-selected which cells my conditional formatting applied to and it fixed the issue immediately (in that past instance, the cells that the conditional formatting applied to had become convoluted through the addition of new rows to the excel over time, so I reselected which cells the formatting applied to as one large group of cells [e.g. D4:D50] and that solved the issue at that time). But this current excel in my attachment has brand new conditional formatting rules that I can't adjust any further, so I am trying to find the root cause. This excel uses conditional formatting in a few places (in the attached screenshots, conditional formatting is used on cell C181 to change text color, and is also used in all of the white colored cells in column E to change the text's color, cell's background color, and remove top and bottom cell borders when certain conditions are met).

I am currently using Excel 2013, however the same error occurred back when I used Excel 2007 a year or two ago.

Does anyone know what exactly is causing these cells to disappear, and what I can do to stop it from happening?