Hi everybody,
I need to go through the values of column G ("Good" or "Bad") and select the
data in between. There are few conditions,

If Address1 = "Bad" And Address2 = "Bad" Or Address1 = "Bad" And Address2 =
"Good" Or Address1 = "Good" And Address2 = "Bad" Then

data in between color.index = 40

ElseIf Address1 = "Good" And Address2 = "Good" Then
cell in column G.value = "Ok"

End If

I'm having a real problem in setting the Address1 and Address2 pair and then
go to the next pair. I've posted a similar question today but my explanation
was too confusing.

Thanks in advance for any help

A B C D E F
G
-8 DL 0.0043 106% 22 Bad
-9 STD 2 0.1038 130% 23
-10 STD 2 0.0995 124% 24
-13 DL 0.0044 109% 27
Good
-14 STD 2 0.0865 108% 28
-16 STD1 0.0009 108% 29

-18 STD3 0.003 106% 30
-23 DL 0.0041 101% 37 Good

And so on

Please disregard this one, Tom Ogilvy answer my post.

"gaba" wrote:

Hi everybody,
I need to go through the values of column G ("Good" or "Bad") and select the
data in between. There are few conditions,

If Address1 = "Bad" And Address2 = "Bad" Or Address1 = "Bad" And Address2 =
"Good" Or Address1 = "Good" And Address2 = "Bad" Then

data in between color.index = 40

ElseIf Address1 = "Good" And Address2 = "Good" Then
cell in column G.value = "Ok"

End If

I'm having a real problem in setting the Address1 and Address2 pair and then
go to the next pair. I've posted a similar question today but my explanation
was too confusing.

Thanks in advance for any help

A B C D E F
G
-8 DL 0.0043 106% 22 Bad
-9 STD 2 0.1038 130% 23
-10 STD 2 0.0995 124% 24
-13 DL 0.0044 109% 27
Good
-14 STD 2 0.0865 108% 28
-16 STD1 0.0009 108% 29

-18 STD3 0.003 106% 30
-23 DL 0.0041 101% 37 Good

And so on