For Excel: I need a formula or code so that when cell A changes, cell B and C reset and are erased?

A is a drop down list and B and C are also drop down lists that are dependent on what A does. So if I change the selection in A- B and C need to reset and be blank fields.

For Example. A has a drop down lists of car brands: Toyota, Ford, Mercedes
B has a drop down lists of models of Toyotas, Fords, and Mercedes
and then C has a list of features for each of these cars

So I originally select Toyota, Camry, and a feature.
But then I change that to say Mercedes- I don't want column B to say Camry still.

Thank you!

You don't indicate specific cell references, such as A1, B1, and C1. So, I'm inferring that your letters do refer to columns A.

Assuming your three cells are, in fact, A1, B1, and C1, here is a Worksheet_Change event handler that will do as you wish.

Copy this event handler to the clipboard (highlight the entire event handler, right click inside the highlighted area, and 'Copy'):

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "A1" Then
Range("B1:C1").Value = ""
End If
End Sub

Select the worksheet containing your dependent drop downs and right click the sheet tab at the bottom.

Select 'View Code'.

Paste the event handler into the white editing area to the right (right click inside the area and 'Paste').

Close the VBE (red button - top right).

Make a selection in A1 and B1:C1 will clear contents.