Pecoflyer,

That CF is entirely intentional (apologies if I did not make that clear). I do want the white-colored and black-bordered cell E8 to "disappear" when I mark that item as NA in cell K8 (for example). Cell E8 houses a due date, but when the item in H8 is Not Applicable, no need for the due date, so E8 should disappear. However this CF is restricted only to column E disappearing when column K in the same row has an X in it. There is nothing in that CF rule that would make any other cell in any other row disappear.

My issue is that when I enter info into cells (putting an X in the K column is just one example), MULTIPLE ROWS of cells disappear (see example in my initial screenshot attachment if you cannot duplicate the error in the actual excel), and there is no CF that states to do that. And these multiple rows that disappear are random as to which rows they are in relation to the cell I entered data into. Sometimes it will be a row I entered data into as well as the above and below few rows, sometimes it will be 4 rows above where I entered data, but it is definitely not due to a CF rule I explicitly set (although it could be a bug or unintended consequence of a CF rule I set).