IF Statement within Data Valadtion List - IF Cell equals then list equals, else do nothing.

[steveaus]

Hey Guys,

I have a Data Validation list Question. In Cell H I have 4 options for a Drop Down List - High, Medium, Low, CLOSED

In Cell G I have Open, Closed, In Progress etc.

Now i want to change the value of Cell H (the data valadation) IF cell G = Closed, to CLOSED. But if it = anything else, then do nothing.

Is this possible to do within Data Validation and a formula?


Cheers,
Steve