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

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

Need help added color to data validation and confirming the new data is added to other columns with correct formula.

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

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.

Having problems with a formula to sum up properly with choosing the correct data validation in a column.

Having problems with formulas summing values in data validation column.

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

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

Create Dependent Drop-down Lists with Excel Conditional Data Validation with an answer that is 4 words

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?