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. [TABLE="width: 604"]
<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>[TR]
[TD="class: xl153, width: 252, bgcolor: #4BACC6"] Lead NAMES[/TD]
[TD="class: xl152, width: 110, bgcolor: #4BACC6"]4 am to 5 am[/TD]
[TD="class: xl152, width: 110, bgcolor: #4BACC6"]6 am to 7 am [/TD]
[TD="class: xl151, width: 110, bgcolor: #4BACC6"]10am to 11am[/TD]
[TD="class: xl152, width: 110, bgcolor: #4BACC6"]11am to 12pm[/TD]
[TD="class: xl154, width: 110, bgcolor: #4BACC6"]1pm to 2pm[/TD]
[/TR]
[TR]
[TD="class: xl156, bgcolor: #D9D9D9"]???????[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl155"]NOT AVAIABLE[/TD]
[/TR]
[TR]
[TD="class: xl157, bgcolor: #D9D9D9"]????[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl155"]NOT AVAIABLE[/TD]
[/TR]
[TR]
[TD="class: xl158, bgcolor: #D9D9D9"]???[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl155"]NOT AVAIABLE[/TD]
[/TR]
[TR]
[TD="class: xl158, bgcolor: #D9D9D9"]???[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl155"]NOT AVAIABLE[/TD]
[/TR]
[TR]
[TD="class: xl158, bgcolor: #D9D9D9"]???[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl155"]NOT AVAIABLE[/TD]
[/TR]
[TR]
[TD="class: xl158, bgcolor: #D9D9D9"]????[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl150"]NOT AVAIABLE[/TD]
[TD="class: xl155"]NOT AVAIABLE[/TD]
[/TR]
</tbody>[/TABLE]