Forum Discussion
Yes No in a cell with yes shown unless changed to no
Here is an example of a simple dropdown.
Example is in the included excel file.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
NikolinoDE Thanks for the help, do you know how would i keep the yes reply displayed and only change to no if required
As far as I know, you cannot enter text and a formula in the same cell at the same time.
Can probably only be done via VBA.
If you can use VBA, please send the following information.
Excel version, operating system name and version, an Excel file (without sensitive data),
so as far as possible you can get a suggested solution that suits your needs.
For the next time, with your permission, I recommend that you follow this advice.
Click on the link for detailed information.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
