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

I make drop down in excel and it is working but when i select the "*?" option which i've used in the past to "select all", it is not working.

I need to apply "=IF(O3="X",'Data Validations'!$C$2:$C$7,'Data Validations'!$C$8:$C$13)" this statement in data validation google sheets

MY QUESTION IS ABOUT: Fixing Formulas DESCRIPTION: I need to apply "=IF(O3="X",'Data Validations'!$C$2:$C$7,'Data Validations'!$C$8:$C$13)" this statement in data validation in google sheets

Fixing Formulas DESCRIPTION: MY QUESTION IS ABOUT: Fixing Formulas DESCRIPTION: I need to apply "=IF(O3="X",'Data Validations'!$C$2:$C$7,'Data Validations'!$C$8:$C$13)" this statement in google sheets data validation

i have a data validation list i want it to make dynamic

In 1 column I have a data validation chart with three options. In the next column I have dollars amounts. Is there a way when one of the three options are selected to have another column with running totals for each option?

In Table 2, column B, data is picked from a Data Validation list (4 choices to pick from). In column C, a business name is input. I need a formula on a separate tab that looks for a term in column B and provides the business name in column c, but I want the data returned on the other tab ONLY in a specific set of cells if it matches the term we are searching for.

Make a data validation entry input other information in the sheet.

I have an Excel file where I have added Data Validation to a column, I need that column to also have Drop Down in each row

Can I use an if statement in data validation . for example in Cell A1 I have a total percentage sum formula l that will be between 1 and 100. somehow I want to data validate the cell so that if the sum is over 100% an error is given. Can that be done