I work with Excel 2003.
If cell B1=1 then DELETE cell A1, and if cell B=0 then UNCHANGED.
How can I do this?
Many thanks :)
You cannot delete a value in a cell with a formula in another cell. That kind of job requires VBA.
You could have a worksheet change event evaluate column B. If a value in column B is changed by user input, the cell in colum A in the same row can be treated accordingly. For example
Right-click the sheet tab, select "View Code" and paste the above code into the code window.
Another possibility would be to create a helper column that reflects the values of column A depending on the values in another column. Insert a column between A and B and then use something like this in the (now) column B, starting in B1
Then you can hide column A if desired.
|show 1 more comment|