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