How do I use different colours in drop down menus in Excel 2003?
 

In a spreadsheet I'm using the Validation Data tool to create a drop down
menu for cells but all the background colour is white no matter how I shade
the source cells. Is it possible to shade the cells in the drop down menu?

Regards
Mark

How do I use different colours in drop down menus in Excel 2003?
 

I don't think so.

mbdixon wrote:

In a spreadsheet I'm using the Validation Data tool to create a drop down
menu for cells but all the background colour is white no matter how I shade
the source cells. Is it possible to shade the cells in the drop down menu?

Regards
Mark

--

Dave Peterson

How do I use different colours in drop down menus in Excel 2003?
 

No it is not possible to shade the values in a data validation drop down.
Even in a Combo box that is not possible (you can choose only one colour for
all of the entries).
--
HTH...

Jim Thomlinson


"mbdixon" wrote:

In a spreadsheet I'm using the Validation Data tool to create a drop down
menu for cells but all the background colour is white no matter how I shade
the source cells. Is it possible to shade the cells in the drop down menu?

Regards
Mark

How do I use different colours in drop down menus in Excel 200
 

Try using conditional formatting.
If this was helpful please tick yes.

"Dave Peterson" wrote:

I don't think so.

mbdixon wrote:

In a spreadsheet I'm using the Validation Data tool to create a drop down
menu for cells but all the background colour is white no matter how I shade
the source cells. Is it possible to shade the cells in the drop down menu?

Regards
Mark

--

Dave Peterson
.

How do I use different colours in drop down menus in Excel 200
 

That will color the cell only after a selection is made from the list.

The items in the list itself cannot be colored.


Gord Dibben MS Excel MVP

On Thu, 29 Oct 2009 13:03:01 -0700, Lewy
wrote:

Try using conditional formatting.
If this was helpful please tick yes.

"Dave Peterson" wrote:

I don't think so.

mbdixon wrote:

In a spreadsheet I'm using the Validation Data tool to create a drop down
menu for cells but all the background colour is white no matter how I shade
the source cells. Is it possible to shade the cells in the drop down menu?

Regards
Mark

--

Dave Peterson
.