Help with formatting

Copper Contributor

I am working on a spreadsheet and I am looking to have a cell enter x based when another cell has a value. I want the cell to remain blank when the other cell is blank so when i filter out blanks it disappears with the filter if it is blank. Example would be if C10 is blank so would E10 and E10 would filter if i removed blanks. But if C10 has any kind of value then E10 would have an X in it and not filter because it now has a value. Is this possible?

2 Replies


In E10:


=IF(C10="", "", "x")


This can be filled/copied to other cells in column E.

@HansVogelaarThank you so much that worked. I have been trying to figure that out for a couple days now.