EXCEL in a particular region can only change the settings automatically

I have a spreadsheet set to change automatically, for example, I set the input 1, qualified automatically for the change, 2 for failure.

Set so high, I am in another form, as long as a Input 1 will show you qualified, I do not want to have another form to change automatically, can automatically change the settings in only one region, other regions will not be affected ah?

Yes, you need to select the region, set the cell format digital ? ? ? custom box, type the following, first remove the contents inside, and then enter “[= 1] \ Qualified; [2 =] \ failure “, to determine the point, only to lose,” “content, thus no effect on other parts, if there are other places that need, directly inside the custom in this election Format.What you think quite creative.But that is a function of correction (correct), you have to be borrowed, ha ha!
Normal excel in there with this, if the A column you want to import 1 and 2, In the column B, enter the formula to determine:= if (A1 = 1, “qualified”, if (A1 = 2, “on the pull-down failed “,””)), then can be ok for themselves a macro, In the worksheet on the label (for example, “Sheet1”, “Sheet2”, “Sheet3”) right – to see the code, in the event of a blank area code to paste the following code.Description:The first column enter the code, such as 1, 2, ……And enter the second pass out, not up to standard, ……, the third out as long as the importation of such a code, will be established immediately to the qualified.

Private Sub Worksheet_Change (ByVal Target As Range)
hang = Sheets ( “Sheet1”).Range ( “A1”).End (xlDown).Row

If Target.Column = 3 And (Not (Target = “”)) Then '3 is the original The number of rows of data, according to the need to change their

For i = 1 To hang
If Target = Sheets ( “Sheet1”).Cells (i, 1) Then
Target = Sheets ( “Sheet1 “).Cells (i, 2)
Exit For
End If
Next
End If
End Sub