Excel Drop-Down Colors: Change the Cell, Not the List

How-to basics · Updated November 20, 2026

In Excel, you cannot change the color of the native Data Validation drop-down arrow or the pop-up list itself. You can, however, use Conditional Formatting to color the cell after someone picks an option. Select the cell, go to Home > Conditional Formatting > Highlight Cells Rules > Equal To, enter the option, and choose a format. The steps below show how to set this up and explain what to do if you need a different kind of drop-down.

What You’ll Need

  • A worksheet with an existing drop-down list, or permission to create one.
  • The exact text of the option or options you want to highlight.
  • Microsoft Excel for Microsoft 365 on Windows for the main instructions. Excel for Mac and Excel for the web offer similar conditional-formatting options, though some dialog details can look different.

Step-by-Step

  1. Identify what you want to color. A standard in-cell drop-down made with Data Validation has three parts: the cell that stores the chosen value, the arrow that opens the list, and the list of choices. Excel’s built-in Data Validation list does not offer controls for coloring its arrow or the floating menu. The practical built-in approach is to color the cell based on its selected value. For example, a status cell can show a green fill for Complete and a yellow fill for In progress. If you meant the cell, continue with these steps.
  2. Check that the drop-down is a Data Validation list. Click one of the cells that contains the arrow. On the ribbon, open Data > Data Validation and check the Settings tab. If Allow is set to List, this is a standard validation drop-down. If you cannot find Data Validation, or the arrow stays visible even when the cell is not selected, you may be dealing with a Combo Box control instead. That is a different kind of object; see the FAQ below.
  3. Choose the cell or range to format. Select the cell containing the drop-down. If several cells use the same list and should respond the same way, select the whole range, such as D2:D30, before creating the rule. Applying it to the full range at the start saves you from repeating the setup for each row. Avoid selecting the source list of choices unless your goal is to color those ordinary worksheet cells; formatting the source does not color the pop-up list.
  4. Create a rule for the first choice. With the target cell or range selected, choose Home > Conditional Formatting > Highlight Cells Rules > Equal To. In the dialog, type the option exactly as it appears in the list, including spaces and punctuation. Choose a suggested format from the menu, or select Custom Format to set the appearance yourself. In the Format Cells window, open the Fill tab, choose a background color, and confirm the dialogs. You can also choose a font color if that improves contrast. The cell should change appearance whenever its value matches the text in the rule.
  5. Test the rule by making a selection. Click a target cell, open its arrow, and select the option you used in the rule. The cell should take on the chosen color. Pick a different option to check that the formatting changes or disappears as expected. Conditional Formatting responds to the cell’s value; it does not change the actual color of the drop-down menu while it is open.
  6. Add a separate rule for each color you need. Select the same target range and repeat the Equal To rule for each additional option. For example, you could set Complete to green, In progress to yellow, and Blocked to red. Give each option a distinct fill and, where needed, a readable font color. Exact text matching matters: a rule for Complete will not match Completed. If the list includes many options, consider whether coloring every one will make the sheet harder to read.
  7. Review and adjust the rules. Choose Home > Conditional Formatting > Manage Rules to inspect the rules and the cells they apply to. In the rules manager, check that Show formatting rules for is set to the relevant selection or worksheet, and confirm the Applies to range includes every intended drop-down cell. Edit a rule if the text, color, or range is wrong. If rules overlap or several conditions could apply to one cell, review their order and use Stop If True only when you specifically want later rules to be ignored.
  8. Save and check a few rows. Test the first, middle, and last cells in the target range. Confirm that each selection displays the intended fill and that blank cells look the way you expect. Save the workbook after checking it. If you share the file, remember that Conditional Formatting colors the worksheet cell; it does not alter the Data Validation list’s menu or arrow for other users.

In Excel for Mac, the same general route is available from Home > Conditional Formatting, with dialog labels that can vary slightly by release. In Excel for the web, select the range and use Home > Conditional Formatting to add or edit a rule; if an option you need is missing from the browser interface, open the workbook in the desktop app.

Common Mistakes

  • Expecting the list itself to change color. A Data Validation list is not a formatted menu. Conditional Formatting changes the worksheet cell after a choice is made, not the list items as they appear in the pop-up.
  • Formatting the source cells instead of the selection cells. If the choices are stored in A2:A5 but users select values in D2:D30, applying a fill to A2:A5 only colors those source cells. Create the rules on D2:D30 to color the cells where choices are made.
  • Typing a value that is not an exact match. Extra spaces, a different spelling, punctuation, or a trailing space can stop an Equal To rule from matching. Copy the option from the list or check its source cell carefully.
  • Creating a rule for only one row. If you selected D2 before making the rule, Excel may apply it only to D2. Check Manage Rules and expand the Applies to range to cover the intended cells.
  • Using a fill that makes the text difficult to read. A dark background with dark text can make a value hard to see. Choose a readable font-and-fill combination and consider how the sheet will look when printed or viewed on another screen.
  • Assuming the arrow is always visible. The arrow for a Data Validation drop-down normally appears when its cell is selected. Its visibility is not a color-formatting setting.

Tips

  • Use a small, consistent color key. For example, green for finished, yellow for in progress, and red for blocked is easier to interpret than assigning a different color to every phrase.
  • Apply rules to the full working range, including rows you expect to add later. If you use an Excel Table, check how the rule applies when you add rows; review Manage Rules if new cells do not inherit the formatting.
  • Use light fills for ordinary worksheet cells so text remains clear. If color carries meaning, include the status text as well; color alone may be difficult for some readers to distinguish.
  • Keep your list wording stable. When you rename an option, update the corresponding Conditional Formatting rule too, or the new value may no longer trigger the old rule.
  • If you want different formatting for cells with the same status, set up a separate rule for each value and choose colors with enough contrast. Test the result on the actual screen or print layout you use.
  • Formatting the cells that hold the source options can still be useful as a visual key for the workbook author, but it does not make those colors appear in the validation menu.

Troubleshooting

The cell does not change color. First, check that the rule’s text matches the selected value exactly. Then open Home > Conditional Formatting > Manage Rules and check the rule type, its format, and the Applies to range. Make sure the rule applies to the cell you changed. If you edited the list’s wording, edit the rule to use the new wording as well.

The color appears in the wrong cells. In Manage Rules, inspect Applies to. If the rule should cover D2:D30 but only covers D2, select the correct range or update the range in the manager. Also check that the rule was not accidentally applied to the source list or another column.

The cell stays colored after changing the selection. The new value may also match another rule, or an earlier rule may be taking precedence. Review the rules for that range and remove duplicates or adjust their order. Check that the old color is coming from Conditional Formatting rather than a manually applied fill. To remove a conflicting conditional rule, use Home > Conditional Formatting > Clear Rules and choose the appropriate option carefully; clearing rules can remove other formatting you still need.

You cannot find the drop-down arrow. Click the cell once. A Data Validation arrow typically appears only while that cell is selected. If there is still no arrow, check Data > Data Validation to see whether the cell has a list rule and whether the in-cell drop-down option is enabled. A protected worksheet or a different type of control can also affect how the cell behaves.

The list opens, but its menu is still plain. That is expected for a standard Data Validation list: Conditional Formatting does not style the open menu. If coloring the menu items themselves is a firm requirement, consider whether a separate Combo Box control or a redesigned worksheet interface is appropriate. Controls have different compatibility and maintenance considerations, so test the workbook in the Excel versions your users rely on.

Frequently Asked Questions

Can I change the color of the Data Validation drop-down arrow?
No. Excel does not provide a setting to recolor the arrow on a standard in-cell Data Validation list. You can conditionally format the cell that contains the selected value.

Can I color each option inside the open drop-down list?
Not with a standard Data Validation list. You can color worksheet cells after users choose options, or format the cells containing the source values, but neither changes the appearance of the pop-up list.

Can different choices make the cell show different colors?
Yes. Create a Conditional Formatting rule for each choice and apply the rules to the cell or range with the drop-downs. Each rule can use its own fill and font formatting.

Will the colors work in Excel for Mac or Excel for the web?
Conditional Formatting is available in current Excel for Mac and Excel for the web, although some controls and dialog layouts differ from Windows. If you cannot create or edit a particular rule in the browser, use the desktop app.

What if my drop-down is a Combo Box?
A Combo Box is a separate worksheet control, not a Data Validation list. Some Windows control types have their own appearance settings, but availability and behavior vary, and they are not the same as coloring a validation menu. Check the control’s type and compatibility before rebuilding a shared workbook around it.

Does coloring the source list format the drop-down choices?
No. The source range supplies the list values, but its cell formatting is not carried into the Data Validation pop-up. Use source-cell formatting only if you also want a visual key on the worksheet.

Related

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.