Harrison has attended:
Excel Advanced course
Excel Intermediate course
Excel Introduction course
Format cell as drop-down list if another cell contains certain v
Hi there, I'm looking change the format of one cell to a drop-down list, based on the contents of another cell.
I've currently got a IF statement that automatically fills a number of output cells with either 'Yes' or 'No' depending on what is entered into the input cell (AB1). Here is my IF statement:
=IF(OR($AB$1="Role Fit 1",$AB$1="Role Fit 3",$AB$1="Role Fit 5",$AB$1="Role Fit 7"), "Yes", "No")
Now I also want the option to enter "Custom" into the input cell AB1 and then be able to manually select either 'Yes' or 'No' from a drop-down list in each output cell.
So in addition to my current IF statement, if AB1 (the input cell) contains the text "Custom", I want cell AB2 (an output cell) to be reformatted as a drop-down list with the options of 'Yes' or 'No'.
Please could you advise me on how I can achieve this?
Many thanks,
Harrison
RE: Format cell as drop-down list if another cell contains certa
Hello Harrison,
Thank you for your question. The issue with creating a drop down list in a cell which also contains a formula, is that the formula will be deleted when you pick an item from the drop down list.
Also a formula result can't trigger or create a drop down list in another cell. You would need some VBA coding to do that, but I'm guessing you might not want to go down that route.
All I can suggest at this time is to create a drop down in a cell other than the formula cell, to handle custom outcomes.
I will check with my colleagues, in case any of them have found a solution for this type of scenario. If so, we will get back to you with a solution.
Kind regards
Marius Barnard
STL
