Cell conditional formatting

[tmill29]

I have a cell G9 on my Excel worksheet that links to data on a hidden sheet. The data contains possible contract verbage options that are:

AIP
Standard
Implant Pass Thru
Implant Pass-Thru PPR
No Implant Pass-thru PPR

When one of these is selected, I want one of the two textboxes to grey out so no data can be entered into that textbox that corresponds with the above list. The 2 textboxes are: AB Standard which is cell B124 and Supply UB standard which is cell B125.

If the user selects AIP or Implant Pass Thru, then monetary is to be filled in Supply UB. If they selected one of the other 3, the monetary is to be filled in AB Standard. I am not sure how to use conditional formatting to code this or if I even can. I was thinking an IF statement somehow in cell B124 and B125 that says something about if cell G9 = "whatever" then enable that cell if not grey out. Just not sure how to go about doing that.

[mikeTRON]

You can do this with data validation and logic in them.

Can you post a sample dataset?

[tmill29]

Got my answer:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

If Target <> Range("G9") Then Exit Sub
ActiveSheet.Unprotect

If Range("G9").Value = "Implant Pass-through: Auto Inovice Pricing (AIP)" Then
Range("B69").Locked = True
Range("B67").Locked = False
End If

If Range("G9").Value = "Implant Pass-through: PPR Tied to Invoice" Then
Range("B67").Locked = True
Range("B69").loced = False
End If
ActiveSheet.Protect
End Sub