Dynamic Lists

Hello All

I am looking to define which items appear in a drop down list by entering a 'x' or similar in the adjacent cell. For example, by placing the x's as per example A the list would contain Red, Green and Black. If the x locations were changed as per example B the drop down list would change to contain Yellow and Green. Finally as per the x locations in example C the list would contain Red, Blue and Black. I would prefer to use functions, named ranges and data validation rather than using VBA.

Any ideas how to control the values appearing in a drop down list using a selection process like this would be appreciated.


Capture.JPG

Sample file attached

Thank you for the solution. Greatly appreciated