easy5 pts · first answer countsexceldata-validation

A dropdown for status values

Staff should only pick "Open", "In progress" or "Closed" in column E. Which feature gives a dropdown and blocks other entries?

A.Data Validation with the List optionB.Conditional Formatting with a colour scaleC.Flash Fill from an example cellD.Text to Columns with a delimiter

Discussion 0

Join free to post in the discussion.