I would like to create a pull down menu to limit what a cell contains. For
example, for a column for food groups, I would like the user to select from
a list, such as poultry, red meat, fish... I have not found a way to
implement a pull down menu or even if excel allows a pull down menu. Any
ideas?

Select the cells, select Data/Validation, select List, type in your list
just like you did (no quotes):
poultry, red meat, fish
then click the error Alert tab and put in whatever error message you want.
That's it.

"jirl" wrote in message
...
I would like to create a pull down menu to limit what a cell contains. For
example, for a column for food groups, I would like the user to select
from
a list, such as poultry, red meat, fish... I have not found a way to
implement a pull down menu or even if excel allows a pull down menu. Any
ideas?

jirl wrote:
I would like to create a pull down menu to limit what a cell
contains. For example, for a column for food groups, I would like
the user to select from a list, such as poultry, red meat, fish... I
have not found a way to implement a pull down menu or even if excel
allows a pull down menu. Any ideas?

Try with Data Validation (menu Data, Data Validation).

You can see the basics he

http://www.contextures.com/xlDataVal01.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Look at Data Validation

See here for a comprehensive introduction

http://www.contextures.com/xlDataVal01.html

HTH

"jirl" wrote:

I would like to create a pull down menu to limit what a cell contains. For
example, for a column for food groups, I would like the user to select from
a list, such as poultry, red meat, fish... I have not found a way to
implement a pull down menu or even if excel allows a pull down menu. Any
ideas?

Any suggestions for customizing the font (bold desired) and fill color of
individual items on the list? I did not find an answer at contextures.

"Franz Verga" wrote:

jirl wrote:
I would like to create a pull down menu to limit what a cell
contains. For example, for a column for food groups, I would like
the user to select from a list, such as poultry, red meat, fish... I
have not found a way to implement a pull down menu or even if excel
allows a pull down menu. Any ideas?

Try with Data Validation (menu Data, Data Validation).

You can see the basics he

http://www.contextures.com/xlDataVal01.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

You would have to incorporate "Conditional Formatting" into the drop down
cell as well as the data validation.

Pre XL07 you're allowed 3 conditions (colors) plus the original default
color.

There are alternative approaches to attaining more colors he

http://www.xldynamic.com/source/xld.....Download.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Mike Monahan" wrote in message
...
Any suggestions for customizing the font (bold desired) and fill color of
individual items on the list? I did not find an answer at contextures.

"Franz Verga" wrote:

jirl wrote:
I would like to create a pull down menu to limit what a cell
contains. For example, for a column for food groups, I would like
the user to select from a list, such as poultry, red meat, fish... I
have not found a way to implement a pull down menu or even if excel
allows a pull down menu. Any ideas?

Try with Data Validation (menu Data, Data Validation).

You can see the basics he

http://www.contextures.com/xlDataVal01.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Conditional Formatting did the trick, and I saved the extended conditional
formatter for a rainy day, thanks for the helpful and prompt solution to my
problem!

"RagDyeR" wrote:

You would have to incorporate "Conditional Formatting" into the drop down
cell as well as the data validation.

Pre XL07 you're allowed 3 conditions (colors) plus the original default
color.

There are alternative approaches to attaining more colors he

http://www.xldynamic.com/source/xld.....Download.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Mike Monahan" wrote in message
...
Any suggestions for customizing the font (bold desired) and fill color of
individual items on the list? I did not find an answer at contextures.

"Franz Verga" wrote:

jirl wrote:
I would like to create a pull down menu to limit what a cell
contains. For example, for a column for food groups, I would like
the user to select from a list, such as poultry, red meat, fish... I
have not found a way to implement a pull down menu or even if excel
allows a pull down menu. Any ideas?

Try with Data Validation (menu Data, Data Validation).

You can see the basics he

http://www.contextures.com/xlDataVal01.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

You're welcome, and appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Mike Monahan" wrote in message
...
Conditional Formatting did the trick, and I saved the extended conditional
formatter for a rainy day, thanks for the helpful and prompt solution to my
problem!

"RagDyeR" wrote:

You would have to incorporate "Conditional Formatting" into the drop down
cell as well as the data validation.

Pre XL07 you're allowed 3 conditions (colors) plus the original default
color.

There are alternative approaches to attaining more colors he

http://www.xldynamic.com/source/xld.....Download.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Mike Monahan" wrote in message
...
Any suggestions for customizing the font (bold desired) and fill color of
individual items on the list? I did not find an answer at contextures.

"Franz Verga" wrote:

jirl wrote:
I would like to create a pull down menu to limit what a cell
contains. For example, for a column for food groups, I would like
the user to select from a list, such as poultry, red meat, fish... I
have not found a way to implement a pull down menu or even if excel
allows a pull down menu. Any ideas?

Try with Data Validation (menu Data, Data Validation).

You can see the basics he

http://www.contextures.com/xlDataVal01.html


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy