Forum Discussion
How to make a cell blank if another cell is changed?
i want to update the date of the latest CANS NY and the cell "✔" sould erase itself or change to "x"
If date then hack, otherwise X.
Example in the inserted file.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
NikolinoDE I want when I change the date to a "new date" it should lose the check,
The change in cell C2 should be the trigger to change or erase cell C3,
- or maybe if cell c2 is NOT same as the C2 of previous versions it should change to X
- Unfortunately, I can not follow the meaning of the matter.
Please add a worksheet (without sensitive data) and describe your project exactly on the basis of this file.
Thank you for your understanding and patience
NikolinoDE
I know I don't know anything (Socrates)
