Can you change the text color in a DV Dropdown list? I would like to select
text from the Data Validation dropdown and have the resulting value selected
in the cell colored. Can this be done using Conditional Formatting somehow?
Perhaps a Macro to detect the cell contents change and change the color of
the text depending on the value? Help! :)

"Gord Dibben" wrote:

You cannot change the font size in a DV dropdown.

There are workarounds.

See Debra Dalgleish's site for these.

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


Gord Dibben MS Excel MVP

On Sat, 16 Sep 2006 07:30:02 -0700, Jester
wrote:

If you use a drop down menu list with data validation, the menu is so small
you can't read it. How do you apply normal formatting to improve the
situation (font size, bold, etc.)