Combined list value and custom enter value in same cell and display both values

Dineshja48 

I understand your requirement now. You want the combined custom value and list value to appear in the same cell where the user selects the list value. Unfortunately, Excel doesn't support displaying both a dropdown list selection and custom input simultaneously in the same cell without using VBA, which is not supported in Excel for the web.

However, I can suggest an alternative approach that may achieve a similar result:

1. Use Concatenation:
• Instead of using a dropdown list, you can have the user input their selection directly into the cell along with the custom value.
2. Conditional Formatting for Visual Clarity:
• Apply conditional formatting to the cell to visually distinguish between the custom value and the list value.

Here's how you can set it up:

• In cell A1, have the user input their selection directly, such as "50% (Concern)".
• Apply conditional formatting to cell A1 to turn the text red if a list value is entered. You can use a formula-based conditional formatting rule similar to the one mentioned earlier:
• Select cell A1, go to the "Home" tab, click on "Conditional Formatting," and choose "New Rule."
• Create a rule using a formula like =ISNUMBER(SEARCH("S",A1)). Apply the formatting (e.g., red text) when this formula evaluates to true.

This approach allows users to input both the custom value and the list value directly into the same cell (A1), with conditional formatting applied to visually distinguish when a list value is entered. While it doesn't exactly replicate the behavior you described, it provides a practical workaround within the limitations of Excel for the web.