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?
