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

@DP85364 

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.