Running a Macro Based on a Condition

Hi there,

I have created 'Cancel_Macro' in the attached worksheet to strikethrough and delete the applicable Color cell if 'Cancel' is chosen for status (Data Validation).

I have used the following VBA to set up this condition for the worksheet:

Please Login or Register  to view this content.

Please let me know where I am going wrong.

Any help is greatly appreciated.

Thank you

Never Set Target in Worksheet_Change. Target tells you what cell changed. You wiped it out.

I am guessing you want this:

Please Login or Register  to view this content.