Excel 2003 - default value in a validation drop-down list

J

Jack

I'd like to have an default value set in an validation drop-down list in
Excel 2003.
Is this possible ?

Otherwise, is it possible to change colors from different values in the
drop-down list by opening the list ?So, I don't mean the conditional format
of the cell AFTER the choice is made, but in the list itself.

Thanks,
Jack.
 
D

Debra Dalgleish

You can type the default selection in the cell, then allow users to
select a different item from the dropdown list.

You can't format the items in the dropdown list.
 
Top