Hi

I have a worksheet that has drop down selection validation from list (Keep, Delete and amend).

I have another cell that has validation from list (Wrong, Complete or In Progress).

If the User selects Wrong I would like the cell with the (Keep, Delete and amend) to show Wrong but I can’t as the validation on the list has not got Wrong listed and displays Invalid. Can this be done?