Jun 23 2021 06:06 PM
How do i create a cell with yes displayed with a dropdown to display No if required
Jun 23 2021 11:18 PM
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.
Jun 24 2021 02:32 AM
Hello @Brian1968 ,
It is very simple to create dropdown list. File is attached with an example for you.
Step 1 Select Cells where you want to create dropdown list
Step 2 Go to Data Tab -> Select Data Validation
Step 3 Select List in Allow Section
Step 4 Select Source Cells
*You can select one cell than expand the list by dragging like any other formula.
I hope it will help you.
Thanks.
Jun 24 2021 02:36 PM
@NikolinoDE Thanks for the help, do you know how would i keep the yes reply displayed and only change to no if required
Jun 24 2021 02:36 PM
Jun 25 2021 12:15 AM
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.
Welcome to your Excel discussion space!
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)