#1   Report Post  
Posted to microsoft.public.excel.misc
stumakker
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Art
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
stumakker
 
Posts: n/a
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
Art
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I add input data in the input ranges in drop down boxes. oil_driller Excel Discussion (Misc queries) 1 November 9th 05 10:31 PM
advanced: synchronizing data value across two worksheet drop boxes mdhokie Excel Worksheet Functions 1 October 6th 05 08:46 PM
Excel Drop Down Boxes CRS Excel Discussion (Misc queries) 1 September 21st 05 03:45 PM
dependent drop down boxes and dynamic ranges philcud Excel Worksheet Functions 2 September 1st 05 01:03 PM
Copy drop down boxes and associate to cells dynamically in excel t Killion Excel Worksheet Functions 2 June 10th 05 03:11 PM


All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"