SteveG,

THANK YOU!!! That was EXACTLY what I was looking for!
and thank you to Debra too for the assist as well.

I hate writing code but this board makes it so much less frustrating!

Katie

"SteveG" wrote:


Katie,

Unfortunately, Data Validation does not retain the formatting of the
cells as they appear in the list but you can still get the formatting
you need using Conditional Formatting.

Select the cell where your drop down list is say A1. Select
FormatConditional Formatting. Change the Cell Value is option to
Formula is and enter in =A1="Y". Click FormatFont tab. Change the
font as desired. Click OK. Then Click on Add.

For condition 2 follow the above steps but change the formula to
=A1="N" and select the desired formatting. Click ok and ok again. Now
if you Select Y or N it will format as you instructed in the conditional
formatting.

For the issue with the Names, when you set up the data validation,
click on the Error tab and change the Style drop down from Stop to
either Warning or Information. You can then input a message if you'd
like but it is not required. This will allow users to input names that
do not appear in your list but also alerts them to the fact that they
are entering a value not in the list.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=561437