Share via

I want to select cell fill color from dropdown without changing existing text in cell

Calhoun, Samantha 0 Reputation points
2026-05-20T13:31:25.2066667+00:00

I have created a drop-down list in excel for me to be able to select the cell fill color (red, yellow, or green). What I would like is to be able to select from the drop-down list without erasing the existing text in the cell with the color selection.

For example, I want to be able to type "has been practicing notes for a while, still needs to continue practicing" and select "yellow" from the drop down so that the cell fill color is yellow, but my comment remains in the cell, not have the cell text change to "yellow"

Microsoft 365 and Office | Excel | For education | Windows
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Henry-N 13,640 Reputation points Microsoft External Staff Moderator
    2026-05-20T15:28:14.6933333+00:00

    Hi @Calhoun, Samantha, 

    Thank you for posting your question in the Microsoft Q&A forum. 

    I understand that you want to select a cell fill color from a dropdown list without replacing or removing the existing text in that same cell. 

    To clarify, in Excel a single cell can only store one value at a time, meaning it cannot simultaneously hold both: 

    • Free typed notes (your comment text), and 
    • a dropdown selection (such as “Red”, “Yellow”, or “Green”). 

    So when you select an item from a data validation dropdown, it will always overwrite the current cell content this is expected behavior. 

    You can achieve the effect you're looking for by: 

    • Keeping your text in the main cell, and 
    • Using either: 
      • a separate hidden/helper column for the dropdown, or 
      • VBA (macro) to apply color based on a selection elsewhere 

    The most reliable setup would be: 

    • Column A > your notes (free text) 
    • Column B > dropdown for color selection 
    • VBA or Conditional Formatting > applies fill color to Column A based on Column B 

    This way: 

    • Your text remains intact 
    • Each row can be controlled independently 
    • The solution is scalable and stable 

    I understand this may not be exactly the behavior you were hoping for, but due to how Excel stores values in cells, this is a current limitation. 

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".        

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

  2. Calhoun, Samantha 0 Reputation points
    2026-05-20T13:37:38.2466667+00:00

    I have multiple rows that this would need to be applied to and ideally would want each cell to be changed independently at my discretion, without having to have a separate column of drop downs. I am willing to try a VBA code

    Was this answer helpful?

    0 comments

  3. AI answer

    2026-05-20T13:31:42.6533333+00:00

    Use the drop-down list in a helper cell instead of the same cell that contains the comment text.

    A simple setup:

    1. In one column (for example, column A), keep the comments, such as: has been practicing notes for a while, still needs to continue practicing.
    2. In another column (for example, column B), create the drop-down list with values like Red, Yellow, Green using Data Validation.
    3. Apply conditional formatting to column A based on the value in column B:
      • Select the cells in column A that contain comments.
      • On the Home tab, choose Conditional Formatting and create rules like:
        • If the corresponding cell in column B = "Red", set the fill color of the comment cell to red.
        • If = "Yellow", set fill to yellow.
        • If = "Green", set fill to green.

    This way, selecting a color from the drop-down changes only the cell fill color (via conditional formatting) while the text in the comment cell remains unchanged.

    If the drop-down list is on another worksheet and should not be visible or editable, that sheet can be hidden and protected after setup, as described in the guidance for working with drop-down lists.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.