Formatting Issues

How to Change Excel Text Color Based on a Drop-Down Selection

Chanuka Geekiyanage Oct 1, 2026 869 views

Question details

The user needs to change the font color of a cell automatically when a specific value is selected from an Excel drop-down list.

How to Change Excel Text Color Based on a Drop-Down Selection

Product: Excel
Device & OS: not provided
Scenario: Visually distinguishing priority levels or status indicators (e.g., 'Medium Priority') by changing the font color alongside the background color in a drop-down list cell.
Observed behavior: The cell's background color successfully changes via conditional formatting, but the user is unsure how to configure the existing rule to also update the text color.

Before you start

Ensure you have already set up your drop-down list using Data Validation and take note of the exact text values (like 'Medium Priority') you want to trigger the color change.

Solution 1Recommended

Edit Conditional Formatting to Include Font Color

Modify your existing conditional formatting rule to apply both background and text color changes simultaneously.

Excel's Conditional Formatting feature allows you to customize almost every aspect of cell formatting. If your background color is already changing, you simply need to edit the rule's formatting settings to include a specific font color for the matched value.

Select the target cell

Click on the cell or highlight the range of cells that contain your drop-down list and the existing background color rules.

Open the rules manager

Navigate to the Home tab on the Excel ribbon, click on 'Conditional Formatting' in the Styles group, and select 'Manage Rules'.

Edit the existing rule

In the Rules Manager dialog, select the rule corresponding to your drop-down value (e.g., 'Medium Priority') and click the 'Edit Rule' button.

Adjust the font color format

Click the 'Format...' button, switch to the 'Font' tab in the Format Cells dialog, select your desired text color from the Color dropdown, and click 'OK'.

Apply and save

Click 'OK' on the Edit Formatting Rule window, then click 'Apply' and 'OK' on the Rules Manager window to save your changes.

Edit Conditional Formatting to Include Font Color

Automatic Updates: Once applied, the text color will instantly change alongside the background color whenever you select that specific item from the drop-down menu.

Professional Data Formatting

Automate Cell Formatting with WPS Spreadsheet

WPS Spreadsheet provides a highly intuitive Conditional Formatting tool that allows you to instantly customize text and background colors based on your drop-down selections, making your data tracking effortless.

1. Open your file in WPS: Launch WPS Office and open your spreadsheet document.
2. Select the drop-down cells: Highlight the cells containing your drop-down menus that require color changes.
3. Create a new rule: Go to the Home tab, click 'Conditional Formatting', and choose 'New Rule'.
4. Configure the condition: Choose 'Format only cells that contain', select 'Cell Value' equal to your drop-down text.
5. Set font and background color: Click 'Format', customize both the Font color and Fill color, then click 'OK' to apply.

Completely free and lightweight office suiteSeamless format compatibility with Microsoft Excel (.xlsx)Intuitive conditional formatting rule managerRich built-in color palettes for professional data visualization

microsoft office alternative - wps office

Frequently Asked Questions

Why isn't my text color changing even after saving the rule?

This usually happens if multiple formatting rules conflict. Go to Home > Conditional Formatting > Manage Rules, ensure your desired rule is at the top of the list, and check the 'Stop If True' box to prioritize it over other rules.

How can I apply different text colors for multiple drop-down options?

You need to create a separate conditional formatting rule for each drop-down option. For example, create one rule where the value equals 'High Priority' for red text, and another rule for 'Low Priority' for green text.

Can I highlight the entire row based on a drop-down selection?

Yes. Instead of choosing 'Format only cells that contain', select 'Use a formula to determine which cells to format'. Enter a formula referencing the drop-down cell (e.g., =$A1="Medium Priority"), and apply the rule to the entire row's range.

How do I create the drop-down list in the first place?

Select a cell, go to the Data tab, click 'Data Validation'. Under the Settings tab, choose 'List' from the Allow drop-down, and type your options separated by commas (e.g., High, Medium, Low) into the Source box.

Document & File Issues