Web Reference: Jul 3, 2024 · Read More: How to Make a Drop Down List in Excel Color the Drop-Down List Select the cell range where Data Validation is applied. In the Home tab, select Conditional Formatting and choose New Rule. A dialog box will pop up. Select the rule Format only cells that contain. Select the Format only cells with option Specific Text. Apr 20, 2022 · This tutorial will demonstrate how to add a drop-down list with color formatting in Excel and Google Sheets. To create a drop-down list where the background color depends on the text selected, start with Data Validation in Excel, then use Conditional Formatting to amend the background color. When you create a drop-down list in Excel, it only displays text options. But sometimes you may want it to show colors, too. Although you can’t display colors in the drop-down list, you can still select an option and have the cell automatically change color (thanks to conditinal formatting).
YouTube Excerpt: How to
Color Profile Overview
Color Drop Down List Excel Color Trends 2026: Meanings, Combinations, And Trends Explained Color & Biography
style: $61M - $66M
Salary & Income Sources
Career Highlights & Achievements
Assets, Properties & Investments
This section covers known assets, real estate holdings, luxury vehicles, and investment portfolios. Data is compiled from public records, financial disclosures, and verified media reports.
Last Updated: April 3, 2026
Color Outlook & Future Earnings
Disclaimer: Disclaimer: Color estimates are based on publicly available data, media reports, and financial analysis. Actual numbers may vary.