ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   drop down boxes (https://www.excelbanter.com/excel-discussion-misc-queries/64995-drop-down-boxes.html)

stumakker

drop down boxes
 
Is it possible to change to fonts or fill colours of a cell containing a drop
down box?

Any help would be much appreciated

Thanks

Art

drop down boxes
 
If you made the drop down box using validation then you should be able to
change the colors just like any other cell. If you used a combo box from the
control toolbar, then you've got to right click and go to properties.

Art

"stumakker" wrote:

Is it possible to change to fonts or fill colours of a cell containing a drop
down box?

Any help would be much appreciated

Thanks


stumakker

drop down boxes
 
Hi,

Thanks for your reply.

I can change the colour of the selection from the drop down box but can the
colour be changed so when you drop down the options they are all in different
colours.

Thanks

Stewart

"Art" wrote:

If you made the drop down box using validation then you should be able to
change the colors just like any other cell. If you used a combo box from the
control toolbar, then you've got to right click and go to properties.

Art

"stumakker" wrote:

Is it possible to change to fonts or fill colours of a cell containing a drop
down box?

Any help would be much appreciated

Thanks


Art

drop down boxes
 
I don't think so -- but I really don't know.

Art

"stumakker" wrote:

Hi,

Thanks for your reply.

I can change the colour of the selection from the drop down box but can the
colour be changed so when you drop down the options they are all in different
colours.

Thanks

Stewart

"Art" wrote:

If you made the drop down box using validation then you should be able to
change the colors just like any other cell. If you used a combo box from the
control toolbar, then you've got to right click and go to properties.

Art

"stumakker" wrote:

Is it possible to change to fonts or fill colours of a cell containing a drop
down box?

Any help would be much appreciated

Thanks



All times are GMT +1. The time now is 03:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com