Clearing data when i change selection on drop down lists

[MarioLamaa]

Hi, I currently have a file where there are 4 data validation lists. The first one splits the world into 2 regions, the next 3 are all indirect lists which separates them by region and countries. I have information for each list which I would like to be cleared when I change the selection in the previous drop down list. How could I do this? Thanks

[FDibbins]

Hi and welcome to the forum

To the best of my knowledge, this cannot be done with a regular formula.

A few options come to mind though...
Use Conditional formatting to test if the 2nd/3rd etc value is still valid, based on the value "before" it, and then either change its color if it doesnt match, of in a cell next to it, have text that says something like "needs to change" (or whatever you want), and have that text formatted (regular formatting) to white on white, then CF to change color for "no match" so it "appears"

[MarioLamaa]

Ah ok I see, and yes that would still be a helpful solution I will give that a try now, thanks very much!