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

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
679
How to control the color and fonts of a drop down list set by validation ?
Is it impossible ?
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Dec 3, 2004
Messages
679
I am trying to make the fonts of the drop down box larger....without changing fonts of other value in the sheet.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Dec 3, 2004
Messages
679

ADVERTISEMENT

Do u know validation in Excel ?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
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.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
I'm not saying it is impossible.

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

Forum statistics

Threads
1,147,673
Messages
5,742,530
Members
423,736
Latest member
dracula cyrus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top