VBA change cells based on other cell Text

[keiserj]

Been lookin around the Forum and cant find what im looking for. If someone could point me in the right direction would be great.

What I have:

Have a Drop Down list of:
AVAIABLE
NOT AVAIABLE
Scheduled Audit

Once a Lead selects a time and changes the cell to "Scheduled Audit" I would like the other cell within that time slot to change to "NOT AVAIABLE" Below is a Example of one day i would have 5 days of the same thing.


Thinking of using a Worksheet_Change but not sure how to get started. New to VBA
any help would be appericated. Thank you in advanced. Also if you have any question or need more information let me know.

Lead NAMES	4 am to 5 am	6 am to 7 am	10am to 11am	11am to 12pm	1pm to 2pm
???????	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE
????	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE
???	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE
???	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE
???	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE
????	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE	NOT AVAIABLE

<colgroup><col style="width: 189pt; mso-width-source: userset; mso-width-alt: 9216;" width="252"> <col style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;" span="2" width="110"> <col style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;" span="3" width="110"> <tbody>
</tbody>