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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Data Validation - List of unique values 2
Customise drop down list validation 3
Data Validation List 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Double Drop-Down Validation in Excel 2007 1
Data Validation List (Drop Down) Not Showing 2
Excel Drop Down Box 2

Back
Top