Excel Dropdown List Color Change: What You Can Do Instead

Excel cannot change the color of individual choices inside a standard data-validation dropdown. You can, however, use conditional formatting to color the cell after someone selects an option: create the dropdown with Data > Data Validation, then add a formatting rule for each value you want to highlight.

What Excel can and cannot color

A standard Excel dropdown list created with Data Validation displays choices in a plain popup. Excel does not provide a setting to assign a different font color or fill color to each item in that popup. Coloring the cells that hold the source options does not make those colors appear in the dropdown either.

The practical distinction is between the menu and the worksheet cell. Conditional formatting can change the selected cell’s fill or text color according to its value. For example, selecting “High” can make the cell red, while “Low” can make it green. The dropdown itself remains unchanged; the result appears after a choice is entered in the cell.

This is useful for status fields, priority levels, review decisions, and similar categories. It also avoids relying on color alone to communicate meaning: the cell continues to show the actual word or value, which can be read, searched, and understood when printed in grayscale.

Create a standard dropdown list

In Excel for Microsoft 365 on Windows, select the cell or range that should contain the list. On the Data tab, choose Data Validation, open the Settings tab, set Allow to List, and enter or select the list’s source. For a list stored in H2:H4 on the same worksheet, the Source box can contain =$H$2:$H$4. Leave In-cell dropdown checked, then choose OK.

For example, H2:H4 might contain High, Medium, and Low. Selecting a cell with validation shows the dropdown arrow when that cell is active; the user can then choose one of those entries. Keeping the source values in cells makes it easier to edit the choices later than typing a long series directly into the Source box.

Use clear, consistent entries in the source list. Extra spaces or slightly different spelling can prevent a conditional-formatting rule from matching.
To use a list stored on another worksheet, define a named range for the source and use that name in Data Validation. This avoids relying on a direct cross-sheet reference in the Source box.
Optionally, use the Input Message and Error Alert tabs in Data Validation to explain what belongs in the cell and warn about entries outside the list.

Color the selected value with conditional formatting

Select the dropdown cells, such as B2:B100. Go to Home > Conditional Formatting > New Rule, choose Use a formula to determine which cells to format, and enter a rule for one value. With dropdown cells in B2:B100, the formula =$B2="High" returns TRUE for a row when its cell in column B contains High. Choose Format, set a fill or font color, and confirm the rule.

The dollar sign locks the column reference at B, while the row number remains relative. Because the rule applies to B2:B100, Excel checks B2 for the first row, B3 for the next, and so on. If the dropdown is in another column, replace B with that column. If the selected range begins on a different row, make the formula’s row number match that first row.

Repeat the process for the other entries, using a different formula and format for each. For instance, a Medium rule can use =$B2="Medium", and a Low rule can use =$B2="Low". With B2 containing Medium, the Medium rule evaluates TRUE and applies its chosen format; the other two rules do not match. Each rule should use a distinct visual treatment so that the categories are easy to tell apart.

You can also use the built-in text rules instead of formulas: select the target range, then choose Home > Conditional Formatting > Highlight Cells Rules > Text that Contains. Enter the category text and select a preset format, or choose Custom Format when available. Formula rules are more flexible when you need precise references or want to base a format on another cell.

Example: a color-coded status column

Suppose a project tracker has a Status dropdown in B2:B100 with the choices Not started, In progress, and Complete. A simple scheme might use a light gray fill for Not started, pale blue for In progress, and pale green for Complete. The text remains visible in every cell, so a reader can identify the status without interpreting color.

To set this up, apply the three conditional-formatting rules to B2:B100. Use an exact-match formula for each status, such as =$B2="Complete" for the green format. Then test a few cells by choosing each option from the dropdown. Change a value from In progress to Complete and confirm that the cell’s appearance updates. Conditional formatting responds to the current cell value; you do not need to recolor the cell manually after each selection.

If the color should appear across an entire record rather than only in the status cell, apply the rules to the full table row range instead. For a table spanning A2:F100, the formula can still check the status in column B, but the applied range becomes A2:F100. The dollar sign in =$B2="Complete" keeps the check in column B as Excel evaluates each row, allowing the corresponding row to receive the format.

Choose colors that remain useful

Use color to reinforce a label, not replace it. Red, amber, and green are familiar status signals, but their meanings depend on context; add the words High, Medium, and Low or another clear label as well. A pale fill with dark text is often easier to read than a saturated fill with default font color.

Check contrast: the text should remain readable against the fill, including for small cell text.
Use a consistent meaning throughout the workbook. If green means Complete on one sheet, avoid using it for an urgent warning on another.
Consider readers who have color-vision differences or print worksheets without color. Labels, symbols, or an additional text column can preserve the distinction.
Test the result at the zoom level and print size people will actually use. A subtle color that looks distinct on a large monitor may be difficult to distinguish on paper.

Common problems and how to fix them

The dropdown options stay plain. That is expected. Conditional formatting colors the worksheet cell, not the list popup. There is no standard Data Validation option that gives each popup choice its own color.

A rule does not activate. Check the wording in the rule against the source list, including spaces and punctuation. Also check the rule’s Applies to range and make sure its formula row matches the first row in that range. If the value may contain extra characters, an exact-match formula will not match it; correct the source or deliberately choose a text-containing rule.

The wrong cells change color. Confirm that the formula refers to the column containing the dropdown and that the dollar sign is placed correctly. For a rule applied to B2:B100, =$B2="High" checks column B separately on each row. A reference such as =$B$2="High" locks both the column and row, so every cell in the applied range checks only B2. That absolute reference is appropriate only when every cell should depend on the same fixed cell.

Some entries have no color. A user may have pasted a value that is not one of the listed choices. Data Validation can discourage invalid entries with an error alert, but pasted or filled data can sometimes bypass the expected dropdown interaction. Check the cell’s actual text and the Error Alert setting. Consider adding a separate rule for unexpected values if spotting them matters.

Colors disappear or conflict. Open Home > Conditional Formatting > Manage Rules and inspect the rules, their order, and their Applies to ranges. Rules with overlapping conditions can interact, especially when they set the same formatting property. Exact-match rules for distinct list values usually avoid overlap; remove obsolete rules if the workbook has been edited repeatedly.

Alternatives when the menu itself must look different

If the requirement is specifically to color each choice inside the popup, standard Data Validation is not the right feature. A common workaround is to keep the normal dropdown and show a colored legend beside it, or place conditional formatting on a nearby status indicator. This keeps the input simple while making the available categories visible.

For a more customized interface, some workbooks use form controls or VBA, but these introduce trade-offs. A control is not the same as a regular in-cell validation list, and behavior can differ across Excel for Windows, Mac, and the web. VBA macros also require a macro-enabled workbook and may be restricted by security settings. They are usually unnecessary when the real goal is to color the selected cell or its row.

Another option is an icon set or data bar, but those formats are generally designed to visualize numeric values or thresholds, not to give arbitrary text choices individual popup colors. For a small set of text statuses, clearly labeled conditional formatting is usually easier to maintain and share.

Excel on Windows, Mac, and the web

The main approach—Data Validation for the list and Conditional Formatting for the resulting cell appearance—is available in current Excel versions, although the dialogs can vary by platform. On Windows, use Data > Data Validation to create the list and Home > Conditional Formatting to add the rules. On Mac, the Data Validation and Conditional Formatting commands are also available from the ribbon, but dialog layouts and some rule-management details may look different.

Excel for the web supports data-validation dropdowns and conditional formatting, though some advanced editing controls may be more limited or presented differently from the desktop app. If a workbook’s rule needs careful adjustment and the relevant controls are not available in the browser, open it in desktop Excel. In all versions, the key limitation remains: ordinary data-validation choices do not acquire individual colors in the popup.

Frequently Asked Questions

Can I change the color of the Excel dropdown arrow?
No standard Data Validation setting changes the arrow’s color. You can format the cell and its contents, but the arrow is part of Excel’s dropdown interface.

Can each item in a data-validation list have its own color?
No. The source cells’ formatting is not carried into the popup. Use conditional formatting to color the cell after an item has been selected.

Will conditional formatting change the selected cell automatically?
Yes. Once the rule is applied, Excel evaluates the cell value and updates its formatting when the value changes. The format appears on the worksheet cell, not on the open list of choices.

Can I color an entire row based on a dropdown choice?
Yes. Apply the conditional-formatting rule to the whole row range and write the formula to check the dropdown column with a locked column reference, such as =$B2="Complete" when the status is in column B and the first data row is row 2.

Why does coloring the list source not color the dropdown choices?
Data Validation uses the source values to populate its menu, but it does not copy the source cells’ formatting into that menu. Format the selected cell with conditional formatting or provide a separate color legend instead.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.