ExcelIssue
New Member
- Joined
- May 27, 2015
- Messages
- 1
Hello,
I've been searching the internet for a solution, but not sure one exists:
I want to create a dropdown menu which allows the user to select 'red', 'amber', and 'green' and changes the colour of that cell as appropriate. This part I have achieved successfully.
However I would now also like the cell to contain text that does not change. For example, I want the three cells to read "oranges", "apples" and "pears" - and the user can select the status of these cells (e.g. green = on track, amber = issues, red = not on track) via dropdown menu. The key here is that, if a user selects RED for apples, that the word "apples" still appears in the cell, which is now red in colour. The word "apples" would still appear if the user selects GREEN, but the cell will now be green.
My interim solution now is to place a textbox with "apples" over the cell, however this is causing confusion because users click into the textbox, rather than the dropdown list.
Is there any way to do this?
I've been searching the internet for a solution, but not sure one exists:
I want to create a dropdown menu which allows the user to select 'red', 'amber', and 'green' and changes the colour of that cell as appropriate. This part I have achieved successfully.
However I would now also like the cell to contain text that does not change. For example, I want the three cells to read "oranges", "apples" and "pears" - and the user can select the status of these cells (e.g. green = on track, amber = issues, red = not on track) via dropdown menu. The key here is that, if a user selects RED for apples, that the word "apples" still appears in the cell, which is now red in colour. The word "apples" would still appear if the user selects GREEN, but the cell will now be green.
My interim solution now is to place a textbox with "apples" over the cell, however this is causing confusion because users click into the textbox, rather than the dropdown list.
Is there any way to do this?
