Cells Acting Crazy....Cannot Clear Odd, Corrupted Formatting

[centurymantra]

I am working with an Excel document and discovered that a random section of the document has a large group of cells that are acting....crazy. When pasting into them the cells are alternating between yellow, green and yellow in color and display a filter box next to the cell when clicking in it. The filter box is greyed out and does not do anything. It only appears when actually selecting the cell. I can type into one of these cells and it clears the color but the "ghost" filter box persists. I've attached a picture displaying this behavior. I cannot clear, fill, insert cells, reformat, delete the row or do anything to change this.

Does anyone have some insight for me on this?

Thanks!

 

[centurymantra]

Follow up....the document is inflicting this behavior on every cell of rows 120 -234 from column G to XFD. I have tried deleting the rows, but the new rows in their place exhibit the same behavior.

 

[Fluff]

Looks like you might have some Data Validation in those cells, possibly along with conditional formatting.

 

[centurymantra]

Yeah...it was the conditional formatting. Should have thought of that, but the ghosted filter box was throwing my off. Clearing conditional formatting took care of the issue. The odd thing is that it is applying to a group of rows and I have never in my life applied conditional formatting to rows, let alone this document. I did not have to clear data validation, which has not been used on this document. Conditional formatting also removed the filter appearing on those cells.

Possibly a corrupted document?

 

[Fluff]

There if no way that CF would put those drop arrows (or clear them) on the cell, at least not that I know of.
I still suspect that you have DV on those cells, but I could easily be wrong.