ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to Changing Dropdown text color in a Combo Box. (https://www.excelbanter.com/excel-discussion-misc-queries/152752-how-changing-dropdown-text-color-combo-box.html)

The SA guy

How to Changing Dropdown text color in a Combo Box.
 
How do I change the text color for different items in a combo box.
Lets say I have 3 choices in the dropdown. Yes, Maybe No.
I want €œYes€ to be green and bold , €œMaybe€ to be grey and €œNo€ red.

Changing the cell range where the combo-box pulls from has no effect on the
display in the box itself.

Thanks.


TheJoneser

How to Changing Dropdown text color in a Combo Box.
 
I apoligize but I am not replying to answer your question but rather to ask
my own. I am trying to post a question but this system will not allow me to
do so. However, I can reply to previously posted questions. Can anyone help
me post a question directly? Thank you.

"The SA guy" wrote:

How do I change the text color for different items in a combo box.
Lets say I have 3 choices in the dropdown. Yes, Maybe No.
I want €œYes€ to be green and bold , €œMaybe€ to be grey and €œNo€ red.

Changing the cell range where the combo-box pulls from has no effect on the
display in the box itself.

Thanks.


Zone[_3_]

How to Changing Dropdown text color in a Combo Box.
 
Joneser, if you're using Goggle, you'll need to view the Topic Summary page
(if there's a "Discussions" or "Back to Discussions" link, click on that
first). There should be a "new post" link on the right, not far from the
top of the page. Put the mouse over it and be sure you see a pointing hand,
then click. If you're using Operations Outlook, click on New Post. Any
help?

SA, I don't think you can set the text color of individual items in a combo
box. Someone else may have a different idea on this.
James
"TheJoneser" wrote in message
...
I apoligize but I am not replying to answer your question but rather to ask
my own. I am trying to post a question but this system will not allow me
to
do so. However, I can reply to previously posted questions. Can anyone
help
me post a question directly? Thank you.

"The SA guy" wrote:

How do I change the text color for different items in a combo box.
Lets say I have 3 choices in the dropdown. Yes, Maybe No.
I want "Yes" to be green and bold , "Maybe" to be grey and "No" red.

Changing the cell range where the combo-box pulls from has no effect on
the
display in the box itself.

Thanks.





All times are GMT +1. The time now is 02:26 AM.

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