How to control fonts/color of text in validation list ??

[mrchonginhk]

How to control the color and fonts of a drop down list set by validation ?
Is it impossible ?

 

[Norie]

As far as I know it is 'impossible' without changing the overall Windows settings.

What are you actually trying to do?

Perhaps you could use another approach.

 

[mrchonginhk]

I am trying to make the fonts of the drop down box larger....without changing fonts of other value in the sheet.

 

[Norie]

What are you actually using the dropdown for?

Perhaps you could replace it with one from the Forms or Control Toolbox toolbars.

Then you could change font size etc.

 

[mrchonginhk]

Do u know validation in Excel ?

 

[Norie]

Do u know validation in Excel ?

Yes

Data>Validation...etc

But what are you using it for?

As far as I know if you use it to create dropdowns you can't change the font size.

Perhaps you could use a different method to acheive what you want.

 

[mrchonginhk]

Oh... so you mean this is impossible....

 

[Norie]

I'm not saying it is impossible.

Just that there may be a different way to approach what you ultimately want to do.