Doctor G,

The change event is triggered by choosing a value from the Data Validation dropdown.

Make sure that you haven't disabled events accidentally:

Sub ResetEvents()

Application.EnableEvents = True

End Sub


--
HTH,
Bernie
MS Excel MVP


"DoctorG" wrote in message
...
I set up a Worksheet_Change event so as to change the background color of a
row relevant to the value of the column C cell (True/False). It works after
manually changing the values in Column C.

Following ND Pard's advice I managed to set up Data Validation in the C
Column cells so as to restrict entry to True/False. This works.

The problem is that InCell DropDown Validation does not seem to trigger the
Worksheet_Change event and the row background color does not reflect the
value change anymore.

Is this standard behaviour or am I doing something wrong? If it is standard,
where should I code the background change mechanism so that it works?