Making a macro run

sounds like you want to run this code when user changes someting on the Sheet. Paste it into the SHEET module..

Good suggestion,
Did as suggested, received a Run Time Error '438': Object does not support this property or method

When pressing the 'debug' button the line: If Target.Column = 1 Then is highlighted in yellow and I have no idea what to do

Suggestions?

ahh, because you have column Spelled incorrectly in the code...

Column is misspelled.

HTH,

Smitty

Thanks, however with the following Macro:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
If Target.Value = "Med" Then
Rows(Target.Row).Interior.ColorIndex = 3
Cells(Target.Row, 11) = "Q="","",Q-5"
Else
If Target.Value = "Tasc" Then
Rows(Target.Row).Interior.ColorIndex = 8
Cells(Target.Row, 11) = "M="","",M-2"
Else
If Target.Value = "Nbar" Then
Rows(Target.Row).Interior.ColorIndex = x1ColorIndexNone
Cells(Target.Row, 10) = "M="","",M-2"
Cells(Target.Row, 12) = "O="","",O-3"
Cells(Target.Row, 14) = "Q="","",Q-5"
Else
Rows(Target.Row).Interior.ColorIndex = xlColorIndexNone
End If
End If
End If
End If
End Sub

This is what shows up on the spreadsheet:

File AAA Case Claim Insured's Claim S. F. Date Selected Rep To EXC Hearing
Type Number Insured Number Rep Rep Attorney Received Mediator CK Date CK Daphne CK Date CK Date
Med Q=",",Q-5(Col 11)
Tasc M=",",M-2(Col)
Nbar M=",",M-2(Col 10) O=",",O-3(Col 12) Q=",",Q-5(col 14)

This is what displays ( ) provided by me as a reference, the formula results does not display. Also the color of the lettering is green instead of black?
Any suggestions?