Conditional Format VBA question

[pujo]

Hey gang,
I have trying to figure out the "Conditional Format" in VBA, as I have 5 conditions that I need to work with. I have found several post regarding the question, but I'm not sure I understand.
What I am trying to do is simple (I think), maybe one of you could lend a hand on the first one, and I can do the rest, anyway.....

(This is for calculation vacation time based on years of service)

If cell T8 is 0 then cell P7 = the value of cell S7
If cell T8 is between 1 and 4 then cell P7 = 80
If cell T8 is between 5 and 9 then cell P7 = 120
If cell T8 is between 10 and 19 then cell P7 = 160
If cell T8 is = to (or) greater > 20 then cell P7 = 200

Thanks for any assistance,
Pujo

 

[BarCodeWiz]

Pujo,

Here's a quick "translation" of your code:

    Dim v As Integer
    v = CInt(Range("T8").Text)
    If v = 0 Then
        Range("P7") = Range("S7")
     ElseIf v >= 1 And v <= 4 Then
        Range("P7") = 80
     ElseIf v >= 5 And v <= 9 Then
        Range("P7") = 120
    ElseIf v >= 10 And v <= 19 Then
        Range("P7") = 160
    ElseIf v >= 20 Then
        Range("P7") = 200
    End If

 

[pujo]

That seems to be exactly what I needed.
Thanks & Have a great day!!!!

 

[BarCodeWiz]

No problem at all. Happy to help!