Get instant live Excel expert help to learn how to add data validation in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need help learning how to make drop down menu in excel. I know to use data validation. I want to make the options chose between two cells that will auto populate
Solved by A. B. in 22 mins
Need help added color to data validation and confirming the new data is added to other columns with correct formula.
Solved by M. C. in 30 mins
I have a formula consisting of approximately 500 characters. This is causing an issue when trying to use it for data validation (can't exceed 255 characters). I need a way to put the long formula in a cell and refer to (and run) the formula from the data validation screen
Solved by C. A. in 14 mins
I have a cell which is a drop down data validation set (see column D) with the following values “incomplete”, “in progress”, “complete”. These values come from a range I have set outside the print boundaries in Column J. By default the cells return as "incomplete" until manually changed. I need a need a formula (or VBA script) which will add the date into the adjacent cell (Column E) when either “in progress” or “complete” has been selected. It is important that the date does not update to today’s date every time the project is re-opened. Thanks.
Solved by D. E. in 24 mins
Having problems with a formula to sum up properly with choosing the correct data validation in a column.
Solved by I. D. in 26 mins
Having problems with formulas summing values in data validation column.
Solved by B. H. in 24 mins
Hello I used a template "project tracker". I changed it purpose from projects to offers. I put in offers partial price and total price. I added data validation dropdown list for 3 partial price items, for choosing the price. I added conditional formating to the total price and now I want to sort it by total price...smallest to biggest value. Ex. Offer 1|Part1-60000$|Part2-15000$(or 10000$)|Part3-15000$||Total-90000$; Offer 2|Part1-50000$|Part2-25000$||Total-75000$ After sort, choosen values stay the same but data validation show values for particular cell and cond. formating for total price has the color bar bigger for 75000 than for 90000
Solved by V. S. in 22 mins
I am trying to build a macro that will take the option selected from a drop down menu (excel validation list) and copy and paste data (based on criteria) into this worksheet
Solved by F. L. in 26 mins
Create Dependent Drop-down Lists with Excel Conditional Data Validation with an answer that is 4 words
Solved by D. A. in 23 mins
I am trying to lock or protect cells that have data validation, formatting and /or formulas in a cell. my dad selects the entire row and deletes the data but when he does it also deletes the formatting, data validation info, and the formulas. Is there a way to lock that info but still be able to add the data to a cell?
Solved by V. U. in 17 mins