I need help!!

[jovie]

I write a program to set when I key in in one cell in a column, and the other two column meet the requirement, so the row of it will become to red color, and when I key in in one cell in another column, and another two column will fail to meet the requirement, so the row will become not fill in with any color
Here is my program

If Target.Row > 7 And Target.Column = 8 Then
u = Cells(Target.Row, "U")
v = Cells(Target.Row, "V")
If (u > 5 And v < 8) Or (u < 5 And v < 4) Then
MsgBox "Storage is Low, Please Proceed to Order"
Range("C:V" & Target.Row).Interior.ColorIndex = 3

End If
End If
If Target.Row > 7 And Target.Column = 18 Then
u = Cells(Target.Row, "U")
v = Cells(Target.Row, "V")
If (u > 5 And v > 8) Or (u < 5 And v > 4) Then
Range("C:V" & Target.Row).Interior.Pattern = xINone
End If
End If

However ,the row I select wont turn red and it show error 1004
after I cange the C:V to C, it work ,but it is not working as I try to unfill the color
I mean when I key in data in cells in column 18

 

[JoeMo]

This:

Range("C:V" & Target.Row)

is not a valid range object. Try:

Range("C" & Target.Row, "V" & Target.Row)

 

[jovie]

Thanks a lot, But How should I do to un fill the color, As I want it to be like I key in data in Column 18, so it change the data in V, so as V nv meet the requirement, Therefore, it will be not fill

 

[jovie]

Anyone can help me??