ExcelBanter - how do I use color in drop down list in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I use color in drop down list in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/258763-how-do-i-use-color-drop-down-list-excel.html)

TroyB

how do I use color in drop down list in Excel

I am creating a drop down list with three items in it. I would like for each
item to have it's own color. Is this possible?
--
TroyB

Gord Dibben

how do I use color in drop down list in Excel

Not possible within the dropdown.

You can color the cell after the choice is made using Conditional
Formatting.

Gord Dibben MS Excel MVP

On Fri, 12 Mar 2010 09:39:02 -0800, TroyB wrote:

I am creating a drop down list with three items in it. I would like for each
item to have it's own color. Is this possible?

All times are GMT +1. The time now is 01:18 PM.