The first condition in your CF is that any "x" placed in col K in an even row number will, turn the corresponding background of the cell in col E to gray and the text font color to the same shade of gray.


So, the background becomes gray, borders disappear ( they are not kept in the re-formatting) and text has the same color as the background making it "invisible"

Change the fill colors and/or font colors of the CF to solve it ( and eventually add borders to the CF formatting

Attached Images

Screenshot - 290216 - 18:10:05.png (58.1 KB, 18 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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).