| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Drop-down menus with subset drop-down menus | Excel Worksheet Functions | |||
| Excel drop down menus | Excel Worksheet Functions | |||
| How do I add colours to an Excel drop down menu? | Excel Discussion (Misc queries) | |||
| Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) | |||
| drop down menus in excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
