Then you will have to go the Combo-box route.

Did you check out Debra's site?

I'll direct you to another of her pages which shows how to use a Combo-box.

Note:VBA coding required with this method.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP


On Mon, 10 Jul 2006 15:04:01 -0700, Mindie
wrote:

Yes it is Data Validation. Problem is that I do not want to change the whole
sheet, just what is in the drop-down list.

"Gord Dibben" wrote:

Mindie

What type of drop-down list?

Data Validation? Font size cannot be changed although you can use Zoom to
make the whole sheet larger.

See Debra Dalgleish's site for workarounds.

http://www.contextures.on.ca/xlDataVal08.html#Font


Gord Dibben MS Excel MVP

On Mon, 10 Jul 2006 12:40:02 -0700, Mindie
wrote:

I have a drop down list where I want to change the Font Size. I have tried
changed it in the cells where the data resides and also in the cells where
you have the drop down list and neither way increase the Font Size. I am
sure it is something very simple that I am forgetting. Hope someone has the
answer.