Setting a Default Value in Excel

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

Guest

How do I set a default value in certain cells? The cells are already
validated and I would like to have the default value be one of the validation
values.
 
When do you want the default value to appear?

If you want it to appear when data is entered in a row, you could use
programming. Or, enter the default value in each cell, and hide the
value with conditional formatting. Set it to change font colour when
other data is entered in the row. There are examples here:

http://www.contextures.com/xlCondFormat03.html
 
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

Question about conditional formatting of zeros in Excel 0
Data validation accepts illegal entries when one spreads values 5
[values from validation list] 1
Default Value in a list box 8
Include a value from one cell within text of another cell. 2
Can't located named range 3
Default value in excel 11
Access how do you set a yes/no data type as required? 0

Back
Top