Changing the value of a dropdown list automatically

Hi All

All cells from A6:G12 on the attached spreadsheet contains a drop down list.

What I would like to happen is that when I choose Deleted in Column A It will change all other columns in that row to N/A automatically. Any other value from the list in column A will be variable so will have to be inputed manually.

Is there a way of doing this. Im hoping for a formula solution rather than a macro if possible.

Hope that makes sense

Thanks in advance

Rich